Forum Discussion
Helper IIStatic X-axis in stacked column chart
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.
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.
Super UserHi wenners68
The question is unclear, the graph and table, are using the same logic...
Please share some dummy pbix to work with and more details about the problem ...
wenners68Hi,
Sorry, figured it out.
- Ritaf1983
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.
- wenners68
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 🙂