Forum Discussion

luisadavidson's avatar
luisadavidson
Frequent Visitor
7 years ago

Add percentage column to table visual

Hi all,

 

Sounds like a potentially simple request, but I have a matrix in PBI and I want to add % columns for each column, including the total column. Please could you advise the best way to do this? If I need to create a measure, do I create this in the report view or data view, or edit query mode? Thanks!

 

4 Replies

  • tex628's avatar
    tex628
    Icon for Community Champion rankCommunity Champion

    I would do it as a measure in the report view.
    But i would need to know exactly what you mean by percentage column if you want an example in code. 

    What should they be a % of? 

    • luisadavidson's avatar
      luisadavidson
      Frequent Visitor

      Great, thanks.

       

      They need to be a % of the total number of appointments (which are filtered out of this view).

       

       

      • tex628's avatar
        tex628
        Icon for Community Champion rankCommunity Champion

        It should be easy to do.
        Your visual, is it a matrix with appointment status as the column dimension and a countrows() as the value?