Forum Discussion

admin_xlsior's avatar
admin_xlsior
Post Prodigy
6 years ago
Solved

Databar on matrix

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)   Thank...
Tutorial Requests
  • v-lili6-msft's avatar
    v-lili6-msft
    6 years ago

    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

v-lili6-msft's avatar
v-lili6-msft
Community Support
6 years ago

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