Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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