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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
curtismob
Helper IV
Helper IV

Create a slicer using a measure

Hello,

I have a matrix defined with the following columns as rows.
Options[Category Description],
Options[Option],
Community[_cCommunity with Number],
Options[_cPlan/Elev],
'Option Cost'[Cost Code]

And with the following measure for the value

'Option Cost'[_mOption Cost Code Count Diff]

I want to create a slicer using the 'Option Cost'[_mOption Cost Code Count Diff] measure, in order to filter out rows with values of zero.  I have created calculated tables in the past to do this, but not with multiple column/row levels.  Unfortunately, I can't make my pbix available. 

Looking for any suggestions/advice, thank you in advance.

@curtismob 

6 REPLIES 6
Daniel_PowerBI
Advocate I
Advocate I

Could it be this simple?

Daniel_PowerBI_0-1698445001754.png

 

This screen shot is from the link provided previously.

 

curtismob_0-1698931278313.png

 

Below is the calculated table used for the slicer, which has a relationship set with the Option table.

 

_tCost Code Count Slicer =
SUMMARIZE(
    Option,
    Option[Community],
    Option[Plan/Elev],
    "CountDiff", 'OptionCost'[_mCost Code Count Diff])

Unfortunately not, the requirement is to be able to toggle on/off including all values or exclude where the 'Option Cost'[_mOption Cost Code Count Diff] measure is zero.

Daniel_PowerBI
Advocate I
Advocate I

Can you supply a fake set in Excel or something?

Because we cant work with column names only

 

Maybe I can mock something up in Excel.

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.