How to build a Slicer for the Lines on a 'Line & Clustered Column' Chart?

[Anonymous · Accepted solution]

Hi @Anonymous ,

Yes, you can do it.

Firstly, create a table contain all lines’ name:

Lines
Line A
Line B
Line C

I noticed that the aggregation method of your lines is Average. Therefore, create a measure to store three lines for calling in the newly created table:

_Line A = AVERAGE('D - ISP'[Line A])

_Line B = AVERAGE('D - ISP'[Line B])

_Line C = AVERAGE('D - ISP'[Line C])

Drag the Lines field of the new table into the Slicer:

Create a measure:

Measure = SWITCH(TRUE(),
SELECTEDVALUE(Lines[Lines]) = "line A", 'D - ISP'[_Line A],
SELECTEDVALUE(Lines[Lines]) = "line B", 'D - ISP'[_Line B],
SELECTEDVALUE(Lines[Lines]) = "line C", 'D - ISP'[_Line C]
)

Place measure on the Line y-axis of the chart, and the final page effect is as shown below:

pbix file is attached.

If you have any further questions please feel free to contact me.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[Anonymous · Accepted solution]

Hi @Anonymous ,

Yes, you can do it.

Firstly, create a table contain all lines’ name:

Lines
Line A
Line B
Line C

I noticed that the aggregation method of your lines is Average. Therefore, create a measure to store three lines for calling in the newly created table:

_Line A = AVERAGE('D - ISP'[Line A])

_Line B = AVERAGE('D - ISP'[Line B])

_Line C = AVERAGE('D - ISP'[Line C])

Drag the Lines field of the new table into the Slicer:

Create a measure:

Measure = SWITCH(TRUE(),
SELECTEDVALUE(Lines[Lines]) = "line A", 'D - ISP'[_Line A],
SELECTEDVALUE(Lines[Lines]) = "line B", 'D - ISP'[_Line B],
SELECTEDVALUE(Lines[Lines]) = "line C", 'D - ISP'[_Line C]
)

Place measure on the Line y-axis of the chart, and the final page effect is as shown below:

pbix file is attached.

If you have any further questions please feel free to contact me.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[Anonymous]

.

[Anonymous]

Hi @Anonymous ,

Modify these three measures:

_Line A = IF("Line A"IN VALUES(Lines[Lines]),AVERAGE('D - ISP'[Line A]))

_Line B = IF("Line B"IN VALUES(Lines[Lines]),AVERAGE('D - ISP'[Line B]))

_Line C = IF("Line C"IN VALUES(Lines[Lines]),AVERAGE('D - ISP'[Line C]))

Put these three measures into the Line y axis, and the page effect is as follows:

The pbix file has been attached, if you have any other questions please feel free to contact me.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[Anonymous]

.

[Anonymous · Accepted solution]

Hi @Anonymous ,

Please try:

Modify the measure syntax as follows:

_Line A = IF(ISFILTERED('Lines'[Lines]),IF("Line A"IN VALUES(Lines[Lines]),AVERAGE('D - ISP'[Line A])),BLANK())

_Line B = IF(ISFILTERED('Lines'[Lines]),IF("Line B"IN VALUES(Lines[Lines]),AVERAGE('D - ISP'[Line B])),BLANK())

_Line C = IF(ISFILTERED('Lines'[Lines]),IF("Line C"IN VALUES(Lines[Lines]),AVERAGE('D - ISP'[Line C])),BLANK())

Other operations remain unchanged, and the page effect is as shown below:

pbix file is attached.

If you have any further questions please feel free to contact me.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[Anonymous]

.