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 able to select two different months in the table below and the data for that month (which are percentages) needs to appear. The corresponding pie charts and graph then need to change so that they reflect the data in the table. Sorry if this is elementary but I can't even work out how to put a filterable date in two different columns in the table.
| Dec 2019 | Jun 2022 |
| ||
A | 12.00 | 11.00 |
B | 8.00 | 8.00 |
C | 12.00 | 11.00 |
D | 14.00 | 16.00 |
E | 9.00 | 12.00 |
F | 12.00 | 10.00 |
G | 2.00 | 2.00 |
H | 3.00 | 4.00 |
I | 27.00 | 22.00 |
J | 1.00 | 1.00 |
K | 0.00 | 3.00 |
100.00 | 100.00 |
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.
3 Replies
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:
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.