Forum Discussion

devika's avatar
devika
Icon for Helper II rankHelper II
2 years ago

slicer - Line chart with selected value and overall value

Hi   Thanks for your time.   I'm creating a line graph showing the total sales and also by region in the same graph. Total sales by year should always be displayed. When a user doesn't select ...
Need Help
devika's avatar
devika
Icon for Helper II rankHelper II
2 years ago

Shreeram04 - Thanks for your time.sorry not really,

  1. I need to show 600,1500,1500 for total by year (always)

 2.  If region A is selected then 100,400,700 ( as a single line for Region A by Year)

3.   If region A and B are selected then 100,400,700 ( as a single line for Region A by Year )  200,500,800 (as a single line for Region B by Year)

 

devika's avatar
devika
Icon for Helper II rankHelper II
2 years ago

Hi - I am taking a step back to show the grand total and just changed the slicer to single select, so it is working fine in this case.

Can anyone please advise if multiselection in the slicer is possible and also show the regions and  lines/plots separately ?

I have seen the post to create parameter but this won't work in the scenario as I need to produce three different graphs - Profit, Loss, Sales interacting to one Region slicer

 

 Measures: (similarly created for Profit)

 

Total_Loss_line = CALCULATE(sum('Table'[Loss]),All('Table'[Region]))
 
Total_Loss_Selected =
IF (
    ISFILTERED('Table'[Region]),
    CALCULATE(SUM('Table'[Loss])),
    SUM('Table'[Loss])
)