Forum Discussion
Bar Chart sum total when slicer = Select All
Hi,
I'm facing this issue that I cannot group the customer total when my slicer = Select All
my bar chart displayed customer individually instead of sum total.
I would like to display my bar chart as below.
Anyone have idea or any solved similar issue that I can refer to?
Thank you.
MMQuestions7 Hey,
You can use like below measure to get result.Total sale all = CALCULATE(SUM(financials[ Sales]),ALL(financials[Date]))Total profit = CALCULATE(SUM(financials[Profit]),ALL(financials))Thanks
Harish M
4 Replies
- HarishKM
Super User
MMQuestions7 Hey,
You can use like below measure to get result.Total sale all = CALCULATE(SUM(financials[ Sales]),ALL(financials[Date]))Total profit = CALCULATE(SUM(financials[Profit]),ALL(financials))Thanks
Harish M
- amitchandak
MMQuestions7 , You follow my approach of single select with all , but you do not need single select. Just leave it multi select . on Axis use the all column from new dim
Single Select with Select All : https://youtu.be/plGqCEZRfXU
Hi amitchandak ,
It doesn't work on my chart, the list of customers still displayed individually. Single select = off.Hi amitchandak ,
How to change the customer name = "All Customer" in the chart when "ALL" selected in slices?
