Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
The screenshot below shows different investment benchmarks and five associated rows with each benchmark:
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.
Thanks in advance!
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
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!