Forum Discussion
Display 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.
Hi Icey
Thanks for the reply. I appreciate your approach but I don't want the "State" to be repeated for all the linked items when I put it in "Values" section. Is there a way we can acheive it?
I want something like this (edited in paint😀)
Any help is highly appreciated.
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.