conditional formatting

Power BI

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

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

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

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 →