The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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