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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
SammyNed
Helper I
Helper I

Graph with multiple dates

Good Day

 

I have a dataset, similar to below, of leads and their respective dates of when they reached a state. eg: Lead 1 was in a new state on 29 Jan and then moved to a contacted state on 1 Feb etc.

SammyNed_0-1706719806540.png

I would like to create a stacked bar graph similar to the below (the colours of the bars correspond to the stage the lead is in).

I am struggling with the date axis as I created a date table but I can only make 1 relationship.

 

SammyNed_1-1706719867273.png

 

Please help

 

Thanks in advance

 

 

 

1 ACCEPTED SOLUTION
amustafa
Solution Sage
Solution Sage

In your case, un-pivot your leads table so you have same lead id with different date and status column.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

3 REPLIES 3
Anonymous
Not applicable

Hi @SammyNed ,

If I understand correctly, the issue is that you want to create a bar chart. Could you please provide more raw data(exclude sensitive data)  and the desired result with Text format or screenshot to make a deep troubleshooting?

It would be helpful to find out the solution.

You can refer the following links to share the required info:

How to provide sample data in the Power BI Forum

 

Best Regards,

Wisdom Wu

amustafa
Solution Sage
Solution Sage

In your case, un-pivot your leads table so you have same lead id with different date and status column.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Thank you, works perfectly.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.