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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
Vroom_Master3
Helper I
Helper I

Creating a Column and line chart that shows a percentage correct

Hi all,

 

I have some data that is essentially every issue in a particular area. I want to be able to visualize the correct percentage of each issue with a line that runs across the columns. Where a really high value on the columns would mean a low line and no value for a specific column would mean the line is at the top. 

 

I tried solving this issue with Measures and calculations myself, and did some research, but I couldnt find anything. My problem with measures was that i couldnt get the line to move, I could only really get one value, and for a column, its hard to show a percentage with number of values versus total number of values where you can display on a graph, since the value would then be per row, and multiple rows would have to have the same values which doesnt really translate to the line. My guess is grouping, but I I'm not very experienced in messing with groups, especially ones that are flexible to new data coming in. 

 

Heres a sample set: 

1

Wheels

2Lights
3Wheels
4Bricks
5Lights
6Wheels
7Tank
8Wheels
9Wheels
10Lights

 

Imprtant to the data is that there is an option thats not part of the data set, hence 100% success, being Ladders

 

I also created exactly what I want to try and get in PowerBi in Excel, but this wont work in PowerBI as the way I've done it in excel is by making a bunch of Random cells to express what I want. I've also blended the line with adjacent data which I would love to do in power BI too so it isnt a static line, but idk if thats possible and if i can only get a static line to work I'll be happy. 

Exhibit AExhibit A

0 REPLIES 0

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 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.