Databar on matrix

[admin_xlsior]

Hello,

Can we have databar on Grandtotal of the matrix visual ?

As I know, we can in value, through conditional formating, but what I need is only in Grand total only (the last column)

Thanks,

[v-lili6-msft · Accepted solution]

hi, @admin_xlsior 

Yes, you could get it as this way:

For example:

This is a simple sample data

and this is matrix visual

Now create a measure by this logic

Measure = IF(ISFILTERED('Table'[Level2]),BLANK(),SUM('Table'[Value]))

Result:

and here is sample pbix file, please try it.

Regards,

Lin