Forum Discussion

Ola's avatar
Ola
Frequent Visitor
8 years ago
Solved

Change x-axis categories dynamically

Our idea is to change the x-axis dynamically based on a slicer selection. Is this possible, via some DAX measure ? Kind regards, Ola     Sample file: DOS sample file.pbix     We have two ...
Need Help
  • Ola's avatar
    Ola
    8 years ago

    Solved it with a ' resonable work-around', via PQ:

    1. I unpivot the two columns, (which duplicates all rows) but

    2. I set a Chiclet slicer to require a selection, and 

    3. I then just have pay attention to the duplicates, and everything should be fine.

    Thanks for all suggestions

     

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi Ola,

 

Please share a dummy sample in a .pbix file. And the result you want?

 

If the field of the slicer is the same with x-axis, the x-axis will change dynamically. For example, there are three [Year] 2008, 2009, 2010 in the x-axis, it will change automatically based on the selection of the slicer. But if you want to change the x-axis from [Year] to [Country], I'm afraid this isn't supported. Please submit an idea here: ideas.powerbi.

 

I wonder if this is what you want.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards!

Dale

  • Ola's avatar
    Ola
    Frequent Visitor
    8 years ago

    Ok, here is the attempt (.pic + .pbix):

    DOS sample file.pbix

    • v-jiascu-msft's avatar
      v-jiascu-msft
      Microsoft Employee
      8 years ago

      Hi Ola,

       

      A Calculated Column can't be changed dynamically by the slicer. Maybe this is what you want. Add two columns in the axis. You can change the axis by click "Go to next level".

       

       

       

       

       

       

       

       

       

       

       

       

      Best Regards!

      Dale

      • Ola's avatar
        Ola
        Frequent Visitor
        8 years ago

        Thank for the reply Dale. Sorry to say, is not a hierarchy.

        It is two completely unrelated ways to group countries.

        I wish to switch between the two groups, as two different views.

         

        ... via a Calculated Measures, or some trick or ... ?

        I was hoping for something like =SELECTEDVALUES() that could return some sort of "Calculated measure-array/table", or...

        Do you think it is possible ? Or is that 'the limit of DAX' ?