Forum Discussion
slicers
- 7 years ago
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
- 7 years agoHow 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
- Anonymous7 years agoNot applicable
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.
- Anonymous7 years agoNot applicable
Still no luck, followed video to the letter and still only get the table and slicer to work in harmony - the chart remains unaffected my slicer selections.
- MFelix7 years agoSuper User
Hi Anonymous ,
Can you share a sample of your file please?
If the information is sensitive please shared it trough private message.
Regards,
MFelix
- Anonymous7 years agoNot applicable
Hi, thganks for you interest - what is the best way to send/share my files?