Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

DAX

Hello All,Hope everyone is doing excellent. 

I have Data in attached format. I need to show in Power BI two things:

1) A Slicer that contains two Options; Level 1 & Level 2

2) Another Slicer that conatins two options: Target1 & Target2

So, I need to select Level 1 or Level 2 first (either one of both Levels) and then Select target1 or Target 2 (either one of both targets). 

I m not getting any idea to do this in Power BI. Could someone please look into this and let me know?

PS- Level 1 usually designed with a purpose of Higher targets (target1 and2),likewise Level 2 for moderate level of targets (just for reference).

 

Thank you everyone!

Cheers!