Forum Discussion
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 get the label in the X-axis to change when I filter the data?
If I was to select 2022, the table would show Japan at the top and the USA in 3rd place, but column chart will only change the total value, whereas I want those labels to change as well.
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.
6 Replies
Hi,
Sorry, figured it out.
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.
Hi, wenners68
check your Edit interaction option. Set it the way you for both the visual and the slicer.
