Using a variable to slice measures in a graph

Hi Anonymous ,

Thanks for reaching out to the Microsoft fabric community forum.

Create a bar chart that shows multiple measures, but only the selected ones based on a slicer.

1. Create a Disconnected Table with Measure Names

In Power BI, New Table, and create a static list of the measures:

MeasureSelector =
DATATABLE(
"MeasureName", STRING,
{
{"Sales"},
{"Profit"},
{"Cost"}
}
)

This table is not related to your data model.

2. Create a Slicer from the Disconnected Table

• Use the MeasureName column from the MeasureSelector  table as a slicer (set to multi-select).

• Format the slicer as a vertical list or dropdown.
  
  

3. Create a Union Table for Visuals (Optional for Dynamic Axis)

If you want the axis to show measure names, create this table:

ChartAxis =
DATATABLE(
"MeasureName", STRING,
{
{"Sales"},
{"Profit"},
{"Cost"}
}
)

Use  ChartAxis [MeasureName] as the Axis in your bar chart.

4. Create a Measure to Return Values Conditionally

Show Measure Value =
VAR SelectedMeasure = SELECTEDVALUE(ChartAxis[MeasureName])
VAR IsSelected =
CALCULATE(
COUNTROWS(MeasureSelector),
MeasureSelector[MeasureName] = SelectedMeasure
)
RETURN
SWITCH(
TRUE(),
SelectedMeasure = "Sales" && IsSelected, [Sales Measure],
SelectedMeasure = "Profit" && IsSelected, [Profit Measure],
SelectedMeasure = "Cost" && IsSelected, [Cost Measure],
BLANK()
)

Replace [Sales Measure], [Profit Measure], and [Cost Measure] with your actual measures.

5. Build the Visual

• Axis: ChartAxis [MeasureName]

• Values: Show Measure Value

• Slicer: MeasureSelector [MeasureName]

Now select which measures to show using the slicer, and the bar chart will only display bars for the selected ones.

Please Find the attached .pbix file below for your reference.

If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it

Best Regards,
Sreeteja.
Community Support Team