Forum Discussion

vikramkumawat's avatar
vikramkumawat
Advocate II
2 years ago
Solved

Highlight Blank Value in Matrix Visual

Hi Experts, I was trying to implement a matrix visual and apply some conditional formatting to highlight the columns with different background colors.   However, the background color is not ...
Need Help
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi vikramkumawat ,

     

    Thanks Shivu-2000  for the quick reply and solution. Allow me to provide additional insights:

    (1)We can create measures.

    profits = CALCULATE(SUM(Orders[Profit]),ALLSELECTED(Orders),Orders[Country] in VALUES(Orders[Country]),YEAR(calentar[Date]) in VALUES(calentar[Date].[Year]),MONTH(calentar[Date]) in VALUES(calentar[Date].[MonthNo]))
    profit color = 
VAR a = SELECTEDVALUE(calentar[Date].[Month])
RETURN SWITCH(TRUE(),
a = "January","red",
a = "March","green")

    (2) Set up conditional formatting.

    (3) Manually modify the column width of the Profitt Colo to hide it.

     

    Best Regards,

    Neeko Tang

    If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi vikramkumawat ,

 

Thanks Shivu-2000  for the quick reply and solution. Allow me to provide additional insights:

(1)We can create measures.

profits = CALCULATE(SUM(Orders[Profit]),ALLSELECTED(Orders),Orders[Country] in VALUES(Orders[Country]),YEAR(calentar[Date]) in VALUES(calentar[Date].[Year]),MONTH(calentar[Date]) in VALUES(calentar[Date].[MonthNo]))
profit color = 
VAR a = SELECTEDVALUE(calentar[Date].[Month])
RETURN SWITCH(TRUE(),
a = "January","red",
a = "March","green")

(2) Set up conditional formatting.

(3) Manually modify the column width of the Profitt Colo to hide it.

 

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.