Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I am trying to dynamically change the Bar Chart title based on users selection and level of Drill Down/Up, Show Next Level or Expand to next level that is selected. I can dynamically change the portion of the title as it relates to the content of the data but I need help keeping with is keeping the same logic that the defualt chart title uses.
For example, with the default chart title (I have a date hierarchy with just Year & Month) starts with the "...by Year".
- when user clicks on show next level it'll show "...by Month".
- when user clicks on expand down to next level it shows "...by Year and Month".
What is the Dax code to replicate this logic in the title?
Thank you!
Kevin
@sd_kevin , I doubt that. We have isinscope, but that will only work for bars(you can try)
Another option is to try field parameters. Selected all or unselect all it will work like a normal bar. but it will change the title Field Parameters- One solution for Measure Dimension slicer: https://youtu.be/lqF3Wa1FllE?t=70
Thank you for your response. That is unfortunate that the end users cannot mimic the logic of the default dynamic title.
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
104 | |
93 | |
83 | |
64 |