Help required in creating Navigation

[BrianJ]

@Dharma,

@Harsh is absolutely right that you can’t dynamically change backgrounds in Power BI. However, like many things in Power BI, with some ingenuity you can develop workarounds to those constraints. This question came up in another thread recently, related to dynamically changing background colors:

Setting Background Color Based on Dynamic RGB Values

@andrew0101, This is a really interesting question. Like many things in PBI, the technical answer is “no” (becase Page Background doesn’t have a conditional formatting option) , but the practical answer is that we can jury rig PBI elements to successfully mimic that effect. In the solution attached, here’s what I’ve done: created three what-if parameters, Red, Green and Blue created three slicers corresponding to these parameters created a measure (based on a post by David Eldersveld) that …

In addition, here are two other recent threads about manipulating transparency values with DAX. I think these techniques could be used in combination with screen sized buttons filled with the desired images and showing/hiding them based on DAX logic and synching slicers (along the lines of @Greg’s suggestion):

Set a Minimum Sample Size of n Number to Show Visual

Hi all, In my report, I have multiple visuals with different measures and logic. Most of them are based on the count of users. I have a requirement not to show the visual if n <30 for example: if the number of users is less than 30 not to perform the calculation. Is there a way to show a message that Not enough data available when the n < 30 for a visual? that may be applied as a page filter or something? Thanks in advance!

A Trick for Conditional Formatting with Transparent Color To Hide Data Below Sample Size

I appreciate all the help @BrianJ! This is a great trick but doesn’t work for visual that has more than value. Cause if it were more than value you can apply the conditional formatting to it. [data colors] Otherwise it will work great, Not sure still how to tickle this sample size.

I hope this is helpful.

• Brian