Forum Discussion
Helper IIDisplay data in a table visual using two linked tables
Hi ksivaganesh99 ,
How about this:
1. Create a [State Measure] like so:
State Measure = VAR Previous_ = CALCULATE ( MAX ( Table1[State] ), FILTER ( ALLSELECTED ( Table2 ), Table2[Title] < MAX ( Table2[Title] ) ) ) RETURN IF ( Previous_ = MAX ( Table1[State] ), BLANK (), MAX ( Table1[State] ) )2. Change [Measure] like so:
Measure = SWITCH ( [State Measure], "High", "red", "Medium", "orange", "Low", "blue" )3. Replace [State] column with [State Measure] in the Matrix visual.
4. Set conditional formatting.
BTW, .pbix file attached.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community ChampionI'm not sure I understand what you want. Sounds like you need a matrix visualization but after that, I can't tell if I am looking at source data, current output, expected output or ? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Helper IIThank you for the reply. I updated the question with required details. Any help is very much appreciated.