Forum Discussion
Creating Excel visuals in Power BI
Hi Anonymous ,
That is no issue using the column of the dates you can have the selection on a slicer or on the filter pane and user select the values they need. You can have interactions between different visualization working in different ways
For example create two different slicers for the dates with a single select and then create two charts that will only interact with a single chart each then when they select a value on each slicer returns the value for those specif months. And you could have a third visualization that has both slicer active.
Hi MFelix ,
Thanks for your response. The problem is that I have dates that range over months from Jan 2010 to Dec 2022, and I want the user to be able to select which months they want to compare and for the visuals to change accordingly.
Many thanks
Hi Anonymous ,
That is no issue using the column of the dates you can have the selection on a slicer or on the filter pane and user select the values they need. You can have interactions between different visualization working in different ways
For example create two different slicers for the dates with a single select and then create two charts that will only interact with a single chart each then when they select a value on each slicer returns the value for those specif months. And you could have a third visualization that has both slicer active.