Dynamic chart

[imac]

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 needed for each of the four elements so I have the values I need for the Y Axis but I'm unsure how to display them.  The four elements are a perCapita metric so that I can compare the currently selected company with its Region, Type and ALL:

Something like this

If possible I would like the X-axis to be dynamic too so the visual can be produced for other businesses in other sectors.

I've tried, but failed, to build a dynamic table and being relatively new to PBI, I'm just struggling for the right technique.  Please can someone suggest a method or point me to a resource that will help?

Thank you in advance.

[johnyip]

@imac If this can answer your question, please accept my ansewer as solution so others with similar questions can look for this thread.

[imac]

Thank you @johnyip for the speedy and helpful reply.  I'll see what I an come up with using this technique 👍

[johnyip · Accepted solution]

@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: