Forum Discussion
Solved
Dynamic line chart with multi-select slicer
Hello, I'm currently migrating a report from Qlik to Power BI. In the current report, we have a line chart where users have the option to choose which measures they want to visualize: They ca...
Quiny_Harl , Asume you have three measure for these three lines M1, M2, M3 and you have table where you have these as rows values and you use that as slicer (Table, slicer)
M1 New=
var _cnt = countx(allselected(Slicer), Slicer[Value] ="M1")
return
if(isblank(_cnt), blank(), [M1])
M2 New=
var _cnt = countx(allselected(Slicer), Slicer[Value] ="M2")
return
if(isblank(_cnt), blank(), [M2])
M3 New=
var _cnt = countx(allselected(Slicer), Slicer[Value] ="M3")
return
if(isblank(_cnt), blank(), [M3])
Try these measures inplace of M1, M2 and M3 and the slicer