I am completely, absolutely 100% new at Power BI. This is my first official day, so please bear with me :)
I currently have the following Dashboard:
Now, if I insert an image I can get it it to fill all of the screen except for below the dotted line (my red arrow is pointing at...
I wrote a macro to change format of cell by adding pre-fix "19V". The format change under the hood but the value I see only change after I go to the cell and press Enter.
How to automatically change the visual value as well?
Selection.NumberFormat = """19V""@"
Eg: 12345 => 19V12345 (visual...
I have the below in a Matrix visual. I'd like to add another column in the visual that would compare the "Score" to the %ile columns to give me the correct value.
For example, Team A's score is 0.75. This is more than 0.65 but less than 0.76 so it should be in the 25th %ile. Team B...
I'm a bit confused. I appear to have lost my macros.
I have written multiple codes and have created icons at the top of my excel window. These all appear to work fine but when I open up visual basic I cant see them anymore. What have I done? and how do I correct it? Any help is much...
Veyr very new to BI and need to learn quickly...
I am using the visual: 'card' (So it is populated with a specific number D6) and I would like to click on this visual and to be sent to a different page (Also titled D6) with in the report. Is this possible?
Essentially I have 4 different...
I have clicked on the SaveAs method word in some code in the Visual Basic Editor and would like to see all of the associated File Format types.
After pressing F1 I expected to get context sensitive help but instead a new web browser for Visual Studio 2012 opened which doesn't seem to be...
I am trying to create map visual in Power BI. My data consists of a list of contacts, their nationlity, and a measure for an average amount.
I can create a map visual with a color scale according to the average amount, but I would like to exclude natonalities for which less than...
I have a table of data which I want to represent in a scatter chart.
However, I would like to be able to set a flag against each row in the table to specify whether or not the point should actually appear on the chart or not. This way I can decide which are the pertinent data points to...
I was not able to find a thread similar, so starting this thread.
I am a novice in excel and I am trying to compare the softwares of an application with the master data list.
My questions are as below.
1. I have to compare 2 strings in this scenerio (e.g COL A - microsoft visual...
Hi there, I'm losing my mind with this can someone please save me? I think I need to determine a cell but not sure how?
I am looking for all worksheets to zoom to the value I enter into Cell G138? Doesn't work?
Any help very much appreciated!
I am at a loss.
I have an Add-In I created some time ago and recently used Andy Pope's RibbonX Visual Designer in order to add it to my Ribbon. By the way, AJP's RibbonX Visual Designer is AWESOME!!
Anyway, I decided to add a couple of the Add-In commands to the cell menu. Now, when I...
I have an audit coming up and I need to be able to find information quickly to satisfy the auditor
At A1 I have the thing I need information on this is my search box :
A1= Risk assessment ( I want to know which clause this is under ( the clause # ) and what the clause says)
B1: B52 = a...
I want to give the user options which are conditional on another cell. For example, in cell B4 is a dropdown of numbers:
If number is less than 12 than cell I4 will be grayed out, & be locked.
And if number is greater than 12 than cell I4 will be unlocked
I guess I have to do...
This comment is for Option 1
Just for visual
Just for visual
This comment is a dummy
Just for visual
I am trying to run macro as per the instruction below. It did not work. I opened the module and click inside and then press f5 but did not work. but if I go to menu run-->run, it will work, also if i click on run icon > , it will work.
What could be the issue? thank you
Run a macro...
I am pretty new to PowerBi and am having some difficulty understanding how to make my chart show a run as a running year and not Jan thru Dec. The month I am reporting on starts with the previous month and I need my chart to show May thru April and not January thru December. Some of my months...
I have a simple module that calls a form to allow the user to select a row that sets a header filter and colors. I am trying to figure out how to convert this to vb.net or vb6 so it can be compiled.
All the documentation I found is from 2005 visual studio and it doesn't work in visual studio...
Just a quick question, if I have knowledge of VBA in Excel could i be certain to say that i know Visual Basic ...not for applications. Are they literally both the same programming language?
Don't know if this makes sense lol
It's my first time posting here, and I apologise for what will surely be a question full of incorrect vernacular and confusion. I will however be concise.
So: I'm building a roster for event staff - it should be simple, but I got carried away. The first sheet (Schedule)is where start...