Forum Discussion

Booth070's avatar
Booth070
Frequent Visitor
8 years ago

Temporary custom tables? (Plot grand total)

Hi   Since PBI does not offer the option to plot a grand total when plotting a measure by groups, I am creating custom tables to achieve the result: 1. Create custom summary table by group (Table ...
Need Help
Lind25's avatar
Lind25
Resolver I
8 years ago

Hi

I can't access that file. A screenshot/mock up of your desired result would be most useful.

 

Based on what you are saying, using the ALLEXCEPT function or just applying ALL to some columns, rather than a whole table, should give you the desired result and allow the date slicers to be applied.

Booth070's avatar
Booth070
Frequent Visitor
8 years ago

I woiuld like something like this, where the column total represents all cases (A+B+C+...). At the moment I can only think of making two separate plots (but I find that is not helpful since I am benchmarking and want to be able to compare - therefore want same axis -) or do the calculated table that I mentioned.

 

As I said, it is very important to still be able to filter by the slicers I have selected, specially a date one.

 

Does this clarify? (Sorry, maybe I am not explaining muself as I should)

 

Thanks for your help

  • v-xjiin-msft's avatar
    v-xjiin-msft
    Solution Sage
    8 years ago

    Hi Booth070,

     

    Still need a sample. You can share us your file with One Drive or Google Drive or Dropbox. They are all free.

     

    Thanks,
    Xi Jin.

    • Booth070's avatar
      Booth070
      Frequent Visitor
      8 years ago

      Hi, was having trouble with my acccount but should be able to access it now:

      example pbix