Forum Discussion

imac's avatar
imac
Regular Visitor
3 years ago
Solved

Dynamic chart

Hi there   If possible, I would like to display a very simple, but dynamic, bar chart consisting of just four columns which relate to the currently SELECTEDVALUE.  I have produced the Measures need...
  • johnyip's avatar
    3 years ago

    imac You can do so in the chart title, but not the axis titles.

    Solved: Re: Dynamic Axis Titles & Tooltip Additions - Microsoft Fabric Community

     

    As a workaround, you may insert a textbook / rectangle / etc, and then make its words (textbook) / title (rectangle) dynamic using the technique.

    Or more complexly but having the ability to retain the axis titles when you go to the focus mode, you can create four charts, each of them showing the per Capita metrics in your slicer. But in this case, you should not use a slicer and instead you use four bookmarks to set the visibility of your charts in different scenarios, one scenario showing one chart only. (and you should probably stack four identical-sized charts at the exact same location for beauty purpose).

     

    After placing the charts and setting their visibility into differnt bookmarks correctly, insert four buttons/ shape etc in which their action is set to trigger the bookmarks you have created, like the below: