Forum Discussion
Bar Chart with switch on/off
- 5 years ago
AleFVG , On way is bookmark. Have two visual one without 2019 measure and one with it and use the button to control it
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
Another is have slicer and then check for selected value
if(isfiltered(slicer[slicer]) && selectedvalues(slicer[slicer]) ="Sales 2019 - MTD",[Sales 2019 - MTD], blank())
refer measure slicer approch too
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
AleFVG , On way is bookmark. Have two visual one without 2019 measure and one with it and use the button to control it
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
Another is have slicer and then check for selected value
if(isfiltered(slicer[slicer]) && selectedvalues(slicer[slicer]) ="Sales 2019 - MTD",[Sales 2019 - MTD], blank())
refer measure slicer approch too
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
- AleFVG5 years ago
Helper I
Many thanks amitchandak !