Forum Discussion

gkc's avatar
gkc
Frequent Visitor
4 years ago
Solved

Adding sub-text to matrix

Hello everyone! 

I am working on a dashboard and what I ideally want to do is to add a disclaimer when a person is exporting one of the matrix visuals. Something like:

Table look:

Column 1Column 2
a   1
b2
c3


Table look when exported:

Column 1Column 2
a   1
b2
c3
"Sample text""It can be anywhere the location doesn't matter"

 

However, it seems like that is not a future yet. Instead, I was hoping to add a sub-text to the matrix view. Something like a footer or header maybe. Or add a text box and group them so they can only be downloaded together. So far I couldn't figure out a way to do this. Can someone help, please? 

  • gkc , if you are not using the total column, then you can have it there

     

    using isfiltered or isinscope

    a measure like

    if(not(isinscope(Table[Column1])) , "Text",Format( [Measure], "#,###") )

2 Replies

  • gkc , if you are not using the total column, then you can have it there

     

    using isfiltered or isinscope

    a measure like

    if(not(isinscope(Table[Column1])) , "Text",Format( [Measure], "#,###") )

    • gkc's avatar
      gkc
      Frequent Visitor

      Thank you! I think this is the closest option I have at the moment!