Dynamic X-axis for numerous categories

[sailendra]

Hi All,

I'm stuck in an unusual kind of problem w.r.t Clustered Column Charts in Power BI.

Basically, I have created a measure involving multiple tables to arrive at a number/result/output (in %). 

Now, I need to show the same result across various categories in a clustered column chart. The only problem is there are 90,000+ categories. 

These 90,000+ categories have also been used as slicers.

Our team has agreed to show, overall value when none of the categories is selected (without having to keep the category column in the Axis field, as it takes forever to show the output).

However, when a user selects multiple categories from the slicer, I need to show the selected category in X-axis ( as seen in second image)

Request your kind help.

[v-henryk-mstf · Accepted solution]

Hi @sailendra ,

I did a test and think that the similar solutions provided below can help you, create a measure, use functions such as HASONEVALUE, switch, and filter the slicer to dynamically display the results in the visual.

related solution link: Solved: Dynamic change in X Axis - Microsoft Power BI Community

If the problem is still not resolved, can you provide a test data model (delete sensitive information) so that I can do accurate testing. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.