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...
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.
