Forum Discussion
Create dynamic X asix
Hi All, I am trying to create a dynamic X axis where by the user should be able to select the variable they want to see on the X axis, with the Y axis fixed to Sales, e.g. Sales by Country, Sales...
did ou tried bookmarks ?
Yes this is a possible work around, however if I have 10 dimensions, I require 10 buttons which will take up a lot of space. Having these in a slicer would be more ideal.
I think what you want to do is create dynamic measures
sales by store
sales by dimen 2
sales by dimen 3
sales by dimen 6
sales by dimen 4
sales by dimen 5
use the below video to do it, https://www.youtube.com/watch?v=gYbGNeYD4OY.
if you need more clarification after watching the video, please lemme know where you are getting stuck and also post your power bi file
- @myayar, not quite as this is adjusting the fact used on the Y axis which is a measure. I want to be able to dynamically change the dimension in the x axis which is categorical, and hence is not a measure.
BInewbie you use the same logic for x axis as well.
switch(true(),
selected value from slicer = sales by store, [Store],
selected value from slicer = sales by dimension 2, [Dimension2],
selected value from slicer = sales by city, [City],
....
)