Select calculated measures dynamically

[emfil9198]

Hi everyone, 

I wonder if it is possible to determine which calculated measure we want to show in our matrix dynamically (without needing to go into the data panel on the right) I want my boss to be able to click on the measure he wants to appear on the matrix.. 

For example I would like him to be able to choose only FOB_CAD and BRUT_CAD to appear in this matrix and all the other columns to hide dynamically 

Thanks for your help!

[Wilson_ · Accepted solution]

Hi emfil9198,

Sounds like you would benefit from creating field parameters in the data model. Check out this short tutorial youtube video about field parameters.

----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)

P.S. Need a more in-depth consultation for your Power BI data modeling or DAX issues? Feel free to hire me on Upwork or DM me directly on here! I would love to clear up your Power BI headaches.