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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
mrothschild
Continued Contributor
Continued Contributor

Slice MEASURES in a MATRIX with CONDITIONAL FORMATTING?

The screenshot below shows different investment benchmarks and five associated rows with each benchmark:

  1. Quarterly
  2. Rolling 4Q
  3. Cumulative*
  4. Cumulative Avg Annual* 
  5. Cumulative Sharpe*

Each of the above rows is calculated by a single MEASURE.  The MATRIX is currently working as intended as an initial first step. 

 

As the next step, I'd like to add a new SLICER to the page (shown in the lower left-hand corner) that allows the user to select which of the five associated rows are displayed on the MATRIX.  I have a disconnected TABLE with the measure names that populate the SLICER visual.  I'd also like to be able to retain CONDITIONAL FORMATTING for the individual MEASUREs. Since those MEASUREs each have different conditions in establishing the formatting, I'm guessing this means I cannot combine these five individual measures into a single measure, but am open to trying.  

 

mrothschild_0-1723123373320.png

 

Thanks in advance!

1 REPLY 1
raji_n
Resolver I
Resolver I

You have to write a single measure, that considers the values for formatting and standardize those measures to return values, like for example, if 1 is returned then formatting should be green, 0 is returned then red, something of this sort but in a single measure. Then I think you will be able to set up conditional formatting and slice

 

@mrothschild 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors