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
BInewbie's avatar
BInewbie
Frequent Visitor
8 years ago
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.
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.