Choose the measures using Controls

Question & Answer
1

Assume there are 10 measures (M1, M2, …, M10) in my analysis. From the user perspective these 10 measures are categorized into 3 different buckets (B1,B2,B3).
B1 = M1, M2, M3, M4
B2 = M5, M6, M7
B3 = M8, M9, M10

I wanted to create a control on the top for buckets and the pivot should be filtered based on above Bucket to Measure mapping.

Ex: If I choose B2 in the controls, I should be able to see only M5, M6, M7 measures.

Thanks in Advance

2

Hi @Sai_Prasanna

You can look into creating certain visuals based on your parameter.