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
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
Icon for Solution Sage rankSolution 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