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 by Person, Sales by Store etc.
The data is all contained in the same table.
I understand I can do this through a 'no dax' method by unpivoting the table for all my chosen vairables, however given my data has 10m+ rows, i dont think this will be feasible.
Any advice would be greatly appreciated.
11 Replies
Hi@ BInewbie
You may try to use Drill mode in a visualization in Power BI
Step 1:
Drag Country , Person , Store into Axis together and sales into Value.
Step 2:
Use Drill mode
Result:
Best Regards,
Lin
- Thank you, however I should have been more clear - I’m looking for a user to be able to select there chosen dimension through a slicer.
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
Hey BInewbie
Give this a try. It will allow you to change your X-Axis via a slicer selection, meanwhile you can put whatever you want in the Y-Axis.
https://www.youtube.com/watch?v=lFd2hjkKz_Q
Hope this helps,
Parker
