How to display tables mit blank values

[Florex]

Hey,

im looking for an solution for a good visual / presentation of the dataset.

Example of my dataset:

Identifier	Value1	Value2	Value3	Value4	Value5	Value6	Value7	Value8	Value9
837	Text	(Blank)	Text	(Blank)	(Blank)	(Blank)	Text	(Blank)	(Blank)
837	(Blank)	(Blank)	(Blank)	(Blank)	Text	(Blank)	Text	(Blank)	(Blank)

the dataset has 40 column in this format. (due to presentation just 9 values)

The dataset will be filtered by the Identifier.

I want a conditional formatting by "If Text blank = grey circel - If Text not blank =  rosa circle)

But the important information is just the values with text, so the values which are blank can be ignored.

It is possible do disable values which are blank oder which visual can used to display such much information.

A simple table is confusing cause the size of data.

In best case just the rosa circle will be display...

[v-jiewu-msft · Accepted solution]

Hi @Florex ,

Please try the following methods and check if they can solve your problem:

1.Create the simple table.

2.Right click the value, select conditional formatting and select Icons.

3.Select Rules and field, set two rules and select an icon to apply to each rule.

4.Set the conditional formatting for each value column.

5.The result is shown below.

6.You can also view the following document to learn more about conditional formatting.

Apply conditional table formatting in Power BI - Power BI | Microsoft Learn

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.