Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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")
User | Count |
---|---|
63 | |
59 | |
56 | |
38 | |
29 |
User | Count |
---|---|
82 | |
62 | |
45 | |
41 | |
40 |