Forum Discussion

Namoh's avatar
Namoh
Post Partisan
5 years ago
Solved

Conditional format in matrix table can't exceed 100% (when using measures)

Hi,   I've got a matrix table with 4 columns.   I would like to color two of these columns (based on the other two columns) via conditional formatting. The colors should be shown via the followi...
Need Help
Show and Tell
  • v-lili6-msft's avatar
    v-lili6-msft
    5 years ago

    hi Namoh 

     

    here still is Number instead of Percent

     

    Regards,

    Lin

amitchandak's avatar
amitchandak
Super User
5 years ago

Namoh ,

Actually if % type of measure that you should use absolute value. or create a % measure and use absolute value.

 

You can log an issue or Idea if it not working.

https://community.powerbi.com/t5/Issues/idb-p/Issues

https://ideas.powerbi.com/ideas/

 

You can create a color measure and use with field option

example

color =
switch ( true(),
FIRSTNONBLANK('Table'[commodity],"NA") ="commodity1" && sum('Table'[Value]) >500,"lightgreen",
FIRSTNONBLANK('Table'[commodity],"NA") ="commodity2" && sum('Table'[Value]) >1000,"lightgreen",
// Add more conditions
"red"
)
calculate( [NumberofID],DATESMTD('Date dimension 'Table''[Date]), USERELATIONSHIP ('Table'2[CreateDate])
calculate(Max(Target[ratio])) *CALCULATE(
[Sales_Value],
SAMEPERIODLASTYEAR(
Date_DB[Date]))

 

https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values

Namoh's avatar
Namoh
Post Partisan
5 years ago

Thanks for your quick reply, but to be honest, I don't understand what you mean.

 

This is my table, with normal values and the YTD columns are sums of the 1ste/3rd column.

 

If more information is needed, e.g. my measures, to provide a solution that I can work with, please let me know.

 

I looked at the links besides that they are very interesting, I didn't find a solutoin for my issue.