Format String

Power BI

Defining different formats for values and totals

So today I recevied a question on the SML group which looked like the perfect use case for a calculation group. Somebody was trying to build a matrix and wanted to have the values without decimals but the totals with decimals. In other words the goal was defining different formats for values and tot...
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

Completely arbitrary tables in Power BI

Hello there, this is not an entirely new technique, but then again, maybe the use case will be useful to someone, so I'll go ahead and put it here. Indeed the idea came once again from the whatsapp group of Power BI User Group Barcelona, great people all around. Paul shared with the rest of[...]
Leer post →
Power BI

Charting time as Hours and Minutes

Once again I'll recreate here a use case I found at work because I think it's cool and with some gotcha's that can be fixed. The use case itself is broad enough. We are measuring the duration of an event (working hours, machine runs, etc) and we want to visualize it. Since we want to[...]
Leer post →
Power BI

The ultimate hack to set column widths in a matrix

Ok, I have maybe gone a bit overboard with the title, but I think it has some advantages over other hacks out there to establish the column widths of matrix, so here I am to explain how I came up with it and how to use it. The first hack I saw was from Ben[...]
Leer post →
Power BI

Changing display units without a suffix

This may seem trivial, but it did not pop up in my head at first, so might be useful to somebody else. In sales reports, there are lots of numbers. And if it's a large company these numbers may be very large. So depending on the visual, the full number may be a bit too[...]
Leer post →