Power BI Accelerator Week #3 is Live!

[BrianJ]

@stevens ,

I picked up that trick a while back from @JarrettM, and now do 95%+ of my conditional formatting that way.

An additional cool trick you can add to that is controlling the transparency of the color with two more digits added onto the end of the hex code. See this thread for example:

Set a Minimum Sample Size of n Number to Show Visual

@iasma, Totally doable in Power BI, using a couple of cool tricks to control transparency of visuals via DAX and conditional formatting. Here’s a basic mockup of your scenario that I created: [FEBF7E96-8794-4F02-A291-E54854A2517E] The trick here is to create your visuals as normal, and then create a card that says “Insufficient Sample Size” or something to that effect. You can then use the transparency attribute (00) of hex codes to make the background and font of the overlaying card transp…

• Brian