Forum Discussion
Quiny_Harl
Advocate III
Advocate IIIDynamic 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...
amitchandak
Super User
Super UserQuiny_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