Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper I
Helper I

Measure names in slicer - filter for display in visual

This is an extension of a query I had on a specific format of data (kindly answered by @Datatouille ) - but since it's not the same topic - I've created a unique post to keep things mutually exclusive.


I have a small example model where I calculate a number of measures (cost, revenue, profit) with a time dimension as well (month).




I'd like to display these in a line chart - something like this - with a slicer with the measure names to be able to display whatever measure is selected:




Currently this is done not using the individual measures but by using a Total Amount measure which in this contrived repro model is just a SUM - but my actual model has many measures with completely different formulae - so I can't take quite the same approach.


How would I create a slicer that has a selection of measures, with the measures wired through to the visual?


I imagine one way to go about it would be to:


1) Create a dimension table for date using DISTINCT against source data

2) Manually create a dimension table with measure names

3) Cross join these into a new table

4) Lookup (CALCULATE with FILTER) values in the new table against the measures in the source data table


The problem I see with this is that my actual model has many dimension tables, and a cross join across all of these is going to lead to a massively huge additional dataset in Power BI. It doesn't seem like a very efficient way to do this. It would be much better to be able to create a slicer with measure names that can be selected to filter the visual.


Any thoughts? Is there any way to do this?


Example model can be found at



Impactful Individual
Impactful Individual

Impactful Individual
Impactful Individual

You might want to take a look at this article: Dynamically change the information within a visual via a slicer.

Helpful resources

Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.