filter that selects measures to show on report

[Giada_Togliatti]

Hi,

Is it possibile to use a filter to select measures I want to show on report?

For example I have two measures: sales and profit and I want to use a filter that let me to select which one I want to see on report as card (only sales, only profit or both of them), is it possible in power bi with the using of dax?

Thank you

[v-eqin-msft]

Hi @Giada_Togliatti ,

According to my understand, you want to dynamically display measures, right?

You could use the following formula after creating a table for slicer by Entering data like this:

Measure =
SWITCH (
    SELECTEDVALUE ( forSlicer[Selected] ),
    "Profit", [profitMeasure],
    "Sale", [salesMeasure]
)

My matrix visualization looks like this:

 

Did I answer your question? Please mark my reply as solution ,thank you.

If you have any questions, please upload some insensitive data samples and expected output.

Best Regards,

Eyelyn Qin

[Fowmy · Accepted solution]

@Giada_Togliatti 

You can use a disconnected table to store the names of the measure and call it based on the selection on the column on a slicer.

https://www.blue-granite.com/blog/disconnected-table-power-bi

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn

[amitchandak]

@Giada_Togliatti ,

Refer these one

https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slic...
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...
https://www.youtube.com/watch?v=vlnx7QUVYME