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

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

Hi Anonymous ,

Sorry for I can't implement it perfectly with DAX. That answer is what I tried. It does have a flaw when show aggregating. After discussing with others, I think there may not be a way to fully meet your requirements.

 

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

    Xue Ding, Thanks a ton for your time. I appreciate it. is it possible to raise a thread to vote?

    where we can change Dimensions as well dynamically like measures?