Forum Discussion

rogelep's avatar
rogelep
Regular Visitor
2 months ago
Solved

Ribbon chart data by date

Hello,   I made a ribbon chart with Volume in the y-axis and date at the x-axis. The figures look fine when i display 1 month's worth of data, but when i exceed more than 1 month's data, the ribbon...
Need Help
  • InsightsByV's avatar
    InsightsByV
    2 months ago

    Hi rogelep ,

     

    This is happening due to date hierarchy. Power BI is automatically using date hierachy here. Can you confirm if you are using dates from the date table?

    If so -

    1. Take "DateTable[Date]" in your X axis of the ribbon chart. Do not choose hierarchy here.
    2. The X axis type should be countinuous 

    If this still doesnt solve issue, check the datatype for dates.

     

    Let me know if this solves your issue, if not share your pbix with sample data. I can fix it for you.

     

    If my answer helped, mark this answer as solution. Kudos are appreciated! 🙂

InsightsByV's avatar
InsightsByV
Super User
2 months ago

Hi rogelep ,

 

This is happening due to date hierarchy. Power BI is automatically using date hierachy here. Can you confirm if you are using dates from the date table?

If so -

  1. Take "DateTable[Date]" in your X axis of the ribbon chart. Do not choose hierarchy here.
  2. The X axis type should be countinuous 

If this still doesnt solve issue, check the datatype for dates.

 

Let me know if this solves your issue, if not share your pbix with sample data. I can fix it for you.

 

If my answer helped, mark this answer as solution. Kudos are appreciated! 🙂