This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowJuly 28 - August 9 | Final Round of the Power BI Dataviz World Championships. This is your chance. Learn more
Hello,
I have a column which I've renamed "Year to Date" in a table visualisation. If I set a variable somewhere to May is there a way to program the column heading to be "May YTD" (i.e. put the month name in automatically)
Thanks for your help,
CM
I don't beleive this is possible to make dynamic for the end-user as it is defined at load stage.
I would recommend adding a new measure which returns a string which you can then use as a title, either in the visual itself or on a card above.
I don't know your specifics but something like:
Title = if(hasonevalue([Month]),min([Month])&" YTD","YTD")
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
| User | Count |
|---|---|
| 27 | |
| 22 | |
| 20 | |
| 18 | |
| 14 |
| User | Count |
|---|---|
| 25 | |
| 20 | |
| 20 | |
| 20 | |
| 20 |