Forum Discussion
Dynamic TextBox
In reference to your original post, you wanted to use FIRSTNONBLANK right? If there will only be one value in a column at any time, then you can probably just use the DAX measure:
Title = FIRSTNONBLANK('Table1'[Column_1],'Table1'[Column_1]).
I used that with sample data where there was only one column with one value in a cell out of 15 cells. I was able to get the value in that cell into a card visual. Let me know if that's what you wanted, thanks.
1) define a DAX text measure
2 ) Use a Card Visual displaying the text dax meaure created in nstep 1
Please see Will thompson's MS Data Summit Video in Youtube for example.Create Impactful Reports With Power BI Desktop
around 28th minute mark onwards.
If I just want to have a single cell as the title, how would I set that up?
"Title = FIRSTNONBLANK('sheetName'[columnName], "")" ?
I tried that but it outputs a number.
Basically, the column is completely empty with the exception of the cell that needs to be the title.
wonga Sample Data: Table 'mySheet' contains Column "1Name" that has a string called "Title" in Row #1.
I want the word "Title" to appear in a text box.
The word "Title" is being extracted from a list of strings. So at one time it is "Title", the next time it is "Title B" the next time it is "Title C"...etc. and 'mySheet[1Name]Row#1 updates in the excel sheet.
All I need is something that will reference 'mySheet'[1Name]Row#1 from my data set (which is already loaded in) and set the string equal to whatever appears in 'mySheet'[1Name]Row#1.In reference to your original post, you wanted to use FIRSTNONBLANK right? If there will only be one value in a column at any time, then you can probably just use the DAX measure:
Title = FIRSTNONBLANK('Table1'[Column_1],'Table1'[Column_1]).
I used that with sample data where there was only one column with one value in a cell out of 15 cells. I was able to get the value in that cell into a card visual. Let me know if that's what you wanted, thanks.