Forum Discussion
slicers
Hi, I have created a very simle line chart with time on the x horizontal axis and quatity on the y vertical axis. I have three data sets showing three separate lines - how do I get a slicer to opera...
Hi Anonymous ,
You measures for each column should be something like this:
Measure G = IF ( CONTAINS ( MeasuresSelection; MeasuresSelection[Measure]; "Measure G" ); SUM ( Table1[G] ); BLANK () ) Measure M = IF ( CONTAINS ( MeasuresSelection; MeasuresSelection[Measure]; "Measure M" ); SUM ( Table1[M] ); BLANK () )Then add this measures to your chart and the slicer based on the measure selection table.
See attach PBIX file.
Regards,
Mfelix
- How do you have the slicer table setup?
Do not make any relationship with your data table.
Regards,
MFelix
Hi Anonymous ,
Check this video that contains a description how to have turn off and on slicer for measures in a chart.
Regards,
MFelix
The video was excellent as a new starter to Power BI. I have not yet got the solution to work with my datasets so will try again today. I create the tables but the line graph refuses to follow the slicer selections.