We've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now
Hi
I have this simple visual where it dynamically changes the dates according to dates selected in a slicer, however how do I get the field headings to also change as per selection - thus I want Current and Previous to show the dates like the cards ?
Hi @NadiaLR1234 ,
You cannot dynamically change the name of legend, but you can dynamically change the visual title.
https://mitchellpearson.com/2020/12/29/dynamically-changing-title-names-in-power-bi/
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks but not what I require - I already have the months dax formulas sorted - I need the field names to change on selection - not sure if this can be a feature in the future
@NadiaLR1234 , I doubt you can change legend.
But based on dates used on formula you can get month year etc
example
current period = format(maxx(allselected('Date'), 'Date'[Date]), "MMM-YYYY")
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
| User | Count |
|---|---|
| 56 | |
| 40 | |
| 35 | |
| 18 | |
| 18 |
| User | Count |
|---|---|
| 69 | |
| 64 | |
| 38 | |
| 34 | |
| 23 |