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
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 II
Resolver II

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
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

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.

Top Solution Authors
Top Kudoed Authors