Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
18 | |
15 | |
12 | |
11 | |
8 |
User | Count |
---|---|
24 | |
19 | |
12 | |
11 | |
10 |