Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

SUMMARIZE - Switch Columns using a Parameter/Filter

Hi,   I've added a slicer to my report from a measure, based on the following link: https://community.powerbi.com/t5/Desktop/a-way-to-use-a-measure-for-a-slicer/td-p/2086558   It's all working f...
Need Help
Show and Tell
v-zhangti's avatar
v-zhangti
Icon for Community Support rankCommunity Support
3 years ago

Hi, Anonymous 

 

Can you provide sample data for testing? Sensitive information can be removed in advance. What kind of expected results do you expect? You can also show it with pictures. I look forward to your response.

 

Best Regards,

Community Support Team _Charlotte

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
    3 years ago

    Hi v-zhangti ,

     

    I was going to upload a PBIX file or Excel file but I can't see how to do that. So hopefully these images will help.

     

    In the below images you'll see some filters with purple boarders and some parameters with blue borders. The default setting at this stage is Advertiser and Media Type, as per the original DAX:

     

    With this setting, the Spend Filter shows a MAX value, generated from the original DAX statement, that matches the table below.

     

    However, if I amend these parameters to show Media Sub Type, the MAX value doesn't adjust:

     

    I would like this to adjust based on the parameter selection. Which is where I was wondering if we could swap out Advertiser for Product and Media Type for Media Sub Type in the DAX statement, so this is more dynamic.

     

    Does that help?

     

    Thanks,

    Mark