Conditional formatting of a single cell table

[pharvey7]

Firstly, please bear with me.... I am totally new to Power BI. I'm pretty much self taught, so I may get the terminology wrong!

I have a table visual that contains a single value that is a using the 'Quick Measure' option. I have used the 'Difference from filtered value' option which just excludes blank values.

I am now trying to conditionally format the result... Red if it is greater or equal to zero, Green if it less then zero.

For some reason, although I'm entering the parameters correctly, the cell does not change colour.

Your help would be appreciated!

Phil.

[v-jiascu-msft]

Hi Phil,

You can upload the file to a cloud drive like OneDrive, GoogleDrive then share the download link here.

Best Regards,
Dale

[pharvey7]

Hi Dale,

Thanks for the reply.

Unfortunately, my organisation does not allow uploads to any cloud, so this is not an option.

Although I haven't achieved wat I want, I am no longer persuing this, as it is nolonger relevant.

Thanks to everyone for their time.

[Anonymous]

Hi,

Download pbix file

Is this your requirement???

[pharvey7]

Hi @Anonymous

I'm not sure what you are asking, as the link did not work.

Thanks.

[rajulshah]

Hello @pharvey7,

Instead of using table visual, you can use the 'Advanced Card' custom visual.

Please refer to the following link:

https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104381651?src=office&tab=Overview

Hope this helps.

[pharvey7]

Hi @rajulshah

Thanks for the quick reply.

I've had a look at the Card visual, but it doesn't really give 'the look' I want/need, which was why I chose the Table visual.

Does conditional formatting not work on a single cell table?

[rajulshah]

Can you please share the sample pbix file here?

Would be great if you can.

[pharvey7]

How do I upload a file to here?