Forum Discussion
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 can choose any combinations between the 3 boxes on top. Every box is associated with 2 measures which are visualized on the line chart only when the user select that box.
Is there a way for this to be implemented in Power BI?
3 Replies
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
Quiny_Harl , this is useful, but I have a couple of questions:
The chart legend still shows all four series regardless how many series are selected in the slicer. How can the legend be made to only show the selected measures?
This method does not work if your Power BI report uses an SSAS database. Is there a method to do this when using an SSAS database (other that creating a disconnected table in the data model)?
