DAX

[Anonymous]

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!

[amitchandak · Accepted solution]

Please refer

https://community.powerbi.com/t5/Desktop/Dynamically-choose-columns-based-on-slicer/td-p/438019

https://community.powerbi.com/t5/Desktop/Dynamic-Column-Based-on-Slicer-Selection/td-p/81126

https://community.powerbi.com/t5/Desktop/dynamic-column-selection-based-on-slicer/td-p/397923

[Anonymous]

Hi,

Thanks for guiding me via links. 

@amitchandak