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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register 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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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