Forum Discussion
Value switch for clustered bar chart
Dear Community,
I have two different measures which I would like to visualize in a bar chart.
Now it looks like this way - showing the two measures in the same time.
Is there any solution to apply a switch/filter to select which measure I would like to see on the bar chart separately?
So just to have one selected bar on the chart - see below two screenshot with measure 1 and then with measure 2.
Thank you very much for your support in advance!
Peter
Anonymous , please find the options for measure slicer
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slicer-parameter-table-pattern
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115
https://www.youtube.com/watch?v=vlnx7QUVYME
3 Replies
- littlemojopuppy
Community Champion
There is. Can you explain what would determine when measure A is shown as opposed to measure B?
This is a measure I use in a report...it presents the results of different measures depending on the selection of status.
Enrollment Count = SWITCH( SELECTEDVALUE(ProgramEnrollments[ProgramEnrollmentStatus]), "Active", [Active Enrollments], "Expired", [Expired Enrollments], "Completed", [Complete Enrollments], "Abandoned", [Abandoned Enrollments], DISTINCTCOUNT(ProgramEnrollments[Id]) ) - amitchandak
Super User
Anonymous , please find the options for measure slicer
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slicer-parameter-table-pattern
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115
https://www.youtube.com/watch?v=vlnx7QUVYME Thank you amitchandak , the suggested radacad.com article explains the solution perfectly.
