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 ksivaganesh99 ,
Is this what you want?
If it is, create a Matrix visual like so:
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 ,
Thank you so much for the reply. I want background colors of State column to be changed based on their values. Is it possible with your solution?
Thank you again for the help.
Hi ksivaganesh99 ,
In Matrix visual, if the columns are in "Rows" or "Columns" fields, Power BI is not support to apply conditional formatting on them. It is suggested to put the columns you want to apply conditional formatting to "Values" field.
Measure = SWITCH ( MAX ( Table1[State] ), "High", "red", "Medium", "orange", "Low", "blue" )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.