Forum Discussion
Creating Excel visuals in Power BI
Hi, I'm relatively new to Power BI and have absolutely no idea how to recreate these visuals exactly from excel. Essentially I have data for every month from Jan 2010 to Dec 2022 and I need to be...
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 Anonymous ,
For this you need to unpivot youir columns so you have a column with the date and another with the values:
Now you can use the columsn on your visualizations: