How to get multiple lines on Line Chart when selecting multiple values on a slicer?

0
votes

Line chart represents counts for each year based on year slicer. Which is works fine.

However, when selecting multiple years on a slicer, line chart does not display anything.

Is any way to make it display multiple lines based on multiple selection on a slicer?

Measure :

Total Submitted Test = 
    IF(SELECTEDVALUE(dim_Date[Year]) = 2017, CALCULATE([Total Submitted],dim_Date[Year] = 2017),
    IF(SELECTEDVALUE(dim_Date[Year]) = 2018, CALCULATE([Total Submitted],dim_Date[Year] = 2018),
    IF(SELECTEDVALUE(dim_Date[Year]) = 2019, CALCULATE([Total Submitted],dim_Date[Year] = 2019),
    IF(SELECTEDVALUE(dim_Date[Year]) = 2020, CALCULATE([Total Submitted],dim_Date[Year] = 2020)
    ))))

enter image description here

Expected result:

enter image description here

UPDATE

Not using any legends. But still, when selecting multiple years only 1 line displays.

enter image description here

1
powerbidaxpowerbi-desktop
Can you not just use the [Total Submitted] measure with Year in the Legend box? – Alexis Olson
Not sure why you are thinking this so complex! Just add Month to Axis, Year to Legend, [Total Submitted] to Values field and you should get your required output. – mkRabbani
@Alexis. Not sure what you mean by that, I am not using anything in Legend box. Snip attached. – Serdia
I'm recommending that you do use the Legend box. Try putting the Year column in that box. – Alexis Olson
oh! I went too complicated way! Thank you! Please, post the answer. – Serdia

1 Answers