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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Riaz02
Regular Visitor

Trouble creating a graph

Good day,

 

I am having trouble creating a graph which displayes the ranges on the X-as and counts of those ranges in the y-as.

 

Can someone kindly assist wih it ?

 

Attached is a snip of the data set and the grapgh which i want to create.20240825_153128.jpg20240825_153201.jpg

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Riaz02 , Better to unpivot those columns in the Power query

 

Unpivot Data(Power Query): https://youtu.be/2HjkBtxSM0g

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@Riaz02 , Better to unpivot those columns in the Power query

 

Unpivot Data(Power Query): https://youtu.be/2HjkBtxSM0g

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Amitchandak,

Thank you it worked but i now face a different challenge.

The Grapf is now created but i am struggling to add filters for date and also the system randomly aranges the X-as of the graph. 

How can i add filters and als adjust the position of the information on the X-as ?

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors