Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

YoY Bar Charts

Hi, 

 

I want to show the count for the same period of time year over year in a bar chart once the dates are selected. 

 

It currenlty shows the sum of values across the years, regardless of the date selected. 

 

Please help.

 

date.PNGYoY.PNG

 

 

4 REPLIES 4
v-jiascu-msft
Employee
Employee

Hi @Anonymous,

 

Let's just see the slicer, we can see this is a report about date from 1/1/2018 to 1/10/2018. But you still need the data of 2016 and 2017. It could be complicated. Several measures could help. Can you share you pbix file if possible? A dummy one is enough.

 

Because the solution depends on your data mode. If the dates are from the same column, the dates out of 1/1/2018 to 1/10/2018 will be filtered out.

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-jiascu-msft
Employee
Employee

Hi @Anonymous,

 

It seems the field of the slicer is from a wrong place, which has only dates of 2018. Please check it out. Or maybe there isn't a proper relationship. Please provide the pbix file if possible.

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

The slicer is correct;

 

I want to see data 1/1 - 1/10 for 2018, 2017, & 2016 in the bar charts.

 

 

Anonymous
Not applicable

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.