Matrix not able to get the selected value by Slicer when interaction disabled (even from Measure)

[junkoohara]

I would like to have a Matrix showing each companies' PBR by grouped bt DOE & ROE.

There is a slicer to select the Company Code, once selected I am able to get the DOE & ROE group.

Ideally, I would like to highlight the relevant cell with conditional formatting, based on the selected company code.

When I enable interaction between the slicer and Matrix, it filters the Martix so it will only show the selected value. Which will not what we would like.

But when I disable interaction between the slicer and Matrix, the Measure I put in the Matrix will not able to receive the selected value and not able to highlight the relevant cell.

The slicer and the Matrix is refering to the same table. I am only using one table so no relationship is used.

What I have tried:
- Create a separate table > still I will need the selected value from slicer, so once I connect the Matrix to slicer, it filters

- Try to convert the selected value to solid text, then add to conditinal format. I coudn't find the right DAX to do that.

- Try finding a global variable that can be used, but they all tell me to use Measure... But Measure does not work in the Matrix visual...

- May be starting to think I should create the whole Matrix with Cards...

Any kind advise is welcomed, please note I jusr recently started using PowerBI again so appriciate if you could use simple and clear explanation.

Thank you in advance,

PS: I have uploaded the pbix file in onedrive Demo-community.pbix 

[junkoohara · Accepted solution]

For anyone who has the same problem, I will leave the solution for reference.

What to do:

(1) Create a Master Code table with only the code for slicer

CodeMaster = DISTINCT('Master'[Code])

(2) Change the source of slicer to the CodeMaster[Code]

(3) Add interaction to the slicer and Matrix

(4) Update the Measure used in the Conditional Formatting

[Ritaf1983]

Hi @junkoohara 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[junkoohara]

@Ritaf1983 Thank you so much for reaching out. Demo-community.pbix I have uploaded the pbix file in Onedrive. The expexted outcome in in the pbix as well. Please let me know if you think it is possible to show the expected outcome...