Forum Discussion

Helper II

2 years ago

Solved

Static X-axis in stacked column chart

Hi, I have a measure that calculates the Top 5 countries for a selected year. It works fine if I use a table or matrix, but I want to use it in a column chart. Is there a way to be able dynamically ...

Need Help

Tips and Tricks

Ritaf1983
2 years ago
Hi wenners68
It sounds like you are using a static top n functionality.
Take a look at the linked tutorial about dynamic way :
https://www.youtube.com/watch?v=vnqLb-IqLeQ
it should help.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Ritaf1983
2 years ago
if I understand you correctly and the graph is hierarchical, try to use the linked method :
https://dataninjago.com/2017/12/11/dax-ranking-with-hierarchy-drill-down/
or as I said in my first response: Please share some dummy pbix to work with
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

wenners68

Helper II

2 years ago

Hi,

No, I used this measure:

Top 5 Country Sales =

IF(ISFILTERED(AllSales[Country]),IF([Country Rank] <= 5,[Total Sales],BLANK()),CALCULATE([Total Sales],TOPN(5,VALUES(AllSales[Country]), [Total Sales])))

The issue was that I had a column chart showing the total sales per year, and when I clicked on one of the years, I expected that to work the same way as selecting a year in a slicer. That doesn't work for some reason. But it works perfectly if the year is selected in the slicer 🙂

Ritaf1983