PowerBi

[Anonymous]

Hello everyone. 

I want to create a "line and clustered column chart". For column chart I want the 'Base year' data. 'base year' can be selected from the dropdown slicer for e.g. 2022,2023 etc. and for line chart data should come from 'comparison year'. The 'comparison data' should come from separte slicer just like 'base year' slicer. I have already set up Date tabel. I just want your help on how can I fetch data for selected year and show 'base year' on column chart and 'comparison year' data on line chart.

thank you in advance. 

[Anonymous]

Date	Sales
1/01/2023	400
1/01/2024	25
1/01/2022	200
1/01/2023	100
1/01/2024	150
1/01/2022	125
1/01/2023	300
1/01/2024	164
1/01/2022	159
1/01/2023	154
1/01/2024	148
1/01/2022	143
1/01/2023	138
1/01/2024	132
1/01/2022	127
1/01/2023	121
1/01/2024	116
1/01/2022	111

This is my sample data. I want 2 slicers. For eg one would be 'base year' which could be any year from above and another would be 'comparison year'. I want base year data to show on bar chart and 'comparison year' data on line chart. 

[Ritaf1983 · Accepted solution]

Hi @Anonymous 
Try to download the linked file and see if it solves your issuehttps://drive.google.com/file/d/1akpurw_9pAfU2w2XHC7_STPvRVjWRm2g/view?usp=sharing 

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[Ritaf1983]

Hi @Anonymous 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523