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)

 

Thanks,

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

1 Reply

  • 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