Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Dynamically changing the values based dimen

I was going through this post https://community.powerbi.com/t5/Community-Blog/Dynamically-change-the-information-within-a-visual-via-a-slicer/ba-p/87027   I need to achieve a similar kind of funct...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hello,

 

Here is the sample data. Let me know if you can access it if not then I am not sure how to share the data? any clue?

I have Hierarchy from P1 till P15, I need to show these levels in a horizontal bar and when clicked on a particular level its related values should be seen in the table.

Something like this

 

In switch also, I need to create the measures but with dimensions like P1 .... P15, how is this possible?

 

Any help in this regard would be appreciable.

Thanks,

 

v-xuding-msft's avatar
v-xuding-msft
Community Support
6 years ago

Hi  Anonymous ,

I can't view the sample data. Please try to share it via DropBox.

 

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Kudos are nice too.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Try this link.

    This is dropbox hope it helps.

     

    Thanks,

    • v-xuding-msft's avatar
      v-xuding-msft
      Community Support
      6 years ago

      Hi Anonymous ,

      I created a sample to try. 

      • Create a disconnect table to as a slicer.

      • Create a measure.
      Measure = 
var sel = SELECTEDVALUE('Table'[Product details])
return
SWITCH(TRUE(),sel = "P01",MAX(Sheet1[P0_L01]),sel = "P02",MAX(Sheet1[P0_L02]),1)

       As you seen, it will work fine when other columns show all the data. if we want to show total values of other columns, the measure will just show the max value. 

       

      I attach the sample. If you need to get it by DAX, I think you could choose to show all the data. If you could unpivot table, it might work more perfectly.

       

      Best Regards,

      Xue Ding

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hello Xue Ding,

         

        Thanks for the reply but it is not aggregating the measures based on dimension but displaying MAX() based on the measure.

        Also, as mentioned previously I can not unpivot the columns because I have 15 levels of Hierarchy with data in GB's. I tried doing it but measure values are getting impacted in a whole report.

        How can we do this with DAX? could you help with it? as that will be the last option left

         

        Thanks,

        Zeenat