conditional formatting

Power BI
11 de febrero de 2023

The Ultimate Snapshot Report (part 3)

Hello there,  yes, a third part of the snapshot report and I'm not even sure it's the last one. The thing is that since the last post there has been some major improvements on the set up that I thought are worth sharing. In my previous post I ended up with a small defeat. There[...]
Leer post →
Power BI
28 de junio de 2022

Normalizing conditional formatting bars

Ok, this is one of those things that I might not do in production unless I have the CEO shouting on my ear "I want the bars of the matrix to be smaller so I can read the numbers, and no, you may not use a custom visual for that!". I know that might be[...]
Leer post →
Power BI
30 de octubre de 2021

A dynamic color gradient for values and totals

It's a loooong title (well, it was "Conditional Formatting with divergent color gradient for values and totals"), but it's exactly what I wanted to achieve when I discovered the limitations of the conditional formatting options in the GUI of Power BI Desktop. The key words are "dynamic" in one hand ...
Leer post →
Power BI
11 de abril de 2021

Theme-compliant conditional formatting measures

Ok, this is a rather niche use case, but I'll go ahead anyway, basically because I think it's cool. In conditional formatting in Power BI you have three options: By values, by rules and by measure.  In this last case, you have to provide a measure which provides a hexadecimal code, such as #FFFFFF f...
Leer post →