Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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 |
2 | Lights |
3 | Wheels |
4 | Bricks |
5 | Lights |
6 | Wheels |
7 | Tank |
8 | Wheels |
9 | Wheels |
10 | Lights |
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 A