Forum Discussion

BInewbie's avatar
BInewbie
Frequent Visitor
8 years ago

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...
Need Help
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
8 years ago

BInewbie

 

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 

BInewbie's avatar
BInewbie
Frequent Visitor
8 years ago
@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.
  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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],

    ....

    )

     

    • BInewbie's avatar
      BInewbie
      Frequent Visitor
      8 years ago

      Anonymous

       

      When im using the switch funciton, it is only allowing me to select measures rather than fields. Any advice?

      Similarly in the video, only measures are used.