Forum Discussion
Activate lines based on slicer selection
Fali324 Can you explain a bit more what you're trying to do? I think DAX and possibly calculation groups will help you.
AllisonKennedy
Hi, My data structure is following:
Table - project details
Columns:
Project name - String
Project Annonmised - Boolean
Project Name Displayed - String
Project Number - Whole Number
Table - Stage
Stage - String
Duration - Whole Number
Job Number - Whole number
At the moment, I'm using a line graph which the stage on the x axis, Duration on the Y axis and then I've put the job number in the legend to get all the enteries for indiviual projects.
I have a slicer at the top which has the fields: Project Annonmised and Project Name. At any given point there will be atleast one project which is not annonomised, the rest will be marked as True and the project names will not be visible.
What I would like to do is for all projects marked as False under Project Annonmised the line should connect all the relevent markers and for all the projects marked as true it should only show the markers.
Thank you for looking at this, your help is really appriciated.
Thanks,
Farhad