Dynamically highlight column IDs related to predefined scenarios (scenario slicer selection)

[drbr]

Goal: Using scenario slicer (A, B, C options), I'd like to dinamically highlight/mark (not filter out!!) rows on a table/matrix visual with DimTable data (ID, Title)

ScenarioTable

Scenario	Column ID
A	1
A	3
B	1
B	2
B	4
C	2

DimTable

ID	Title
1	Title 1
2	Title 2
3	Title 3
4	Title 4

Thank you in advance,

drbr

[drbr]

One suggestion/optimization to final solution @camargos88 provided:

_Measure =

VAR _scenario = SELECTEDVALUE(ScenarioTable[Scenario])

VAR _columnId = CALCULATETABLE(VALUES(ScenarioTable[Column ID]); FILTER(ScenarioTable; ScenarioTable[Scenario] = _scenario))

VAR _valueID = FILTER(DimTable; DimTable[ID] in _columnId)

RETURN IF(COUNTROWS(_valueID) = 1; 1; 0)

[vanessafvg]

are you using a slicer to filter?   

you can set your edit interactions do say how you want the visuals to interact between each other 

https://www.youtube.com/watch?v=KQsRHWTF4Bs

[drbr]

Thank you. I am aware of this functionallity, yet it does not provide solution as, to my knowledge, table/matrix can only be cross-filtered and not cross-highlighted.

What I try to achieve is:

• I select a scenario (slicer)
  • From the ScenarioTable I can see, which IDs should be highlited, if I select any of the A, B, C scenario
• On a matrix visuaI I would not like to filter out scenario-matched IDs, only somehow highlight them

Scenario A selected: matrix visuals still displays all 4 IDs, but only ID 1 and 3 are highlighted.

Scenario B selected: matrix visuals still displays all 4 IDs, but only ID 1, 2 and 4 are highlighted.

Scenario C selected: matrix visuals still displays all 4 IDs, but only ID 2 is highlighted.

I guess for highlighting, I would have to use conditional formatting (visual interaction cross-highlighting is not available in matrix visual, only cross-filtering).

There are around 100 scenarios in my case.

Thank you,

drbr

[vanessafvg]

are you able to provide some dummy data with a scenario or share your pbix

[drbr]

I've uploaded the file to Firefox Send: LINK

Thank you,

drbr

[vanessafvg]

hi, unfortunately you are right there doesn't seem to be a way to do it, unless you employ the conditional formatting which as you say is a pain.

maybe this thread will help if you haven't seen it already.

https://community.powerbi.com/t5/Desktop/highlight-specific-rows-in-matrix/td-p/893600

[vanessafvg]

you could also do something like this insead of using the matrix...

what are you after the total, the detail of the id's both?

[drbr]

Unfortunatelly the matrix is the only way to go.

Previously supplied link could work, but I have almost 100 scenarios.

I will keep the thread open if some DAX genius cracks it somehow😊

Thank you,

drbr 

[vanessafvg]

also i see there is this idea on the ideas forum, maybe vote on it?

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/18765976-cross-highlighting-with-...

[drbr]

Voted😎

[camargos88 · Accepted solution]

Hi @drbr ,

Does it work for you ?

If yes, check this file: Download PBIX 

[drbr]

Excellent. I've just came her to tell, I've manged to solve it myself and the I see this post😁. I practically did it in the same way as you. Such an approach can also work in various similar scenarios.

Well done, Sir!

Regards,

drbr

[vanessafvg]

gotta buy that lotto ticket 🙂