Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello Colleagues!
I'm trying to come up with the followin chart - this one was built in Excel:
It is a column chart that shows the Quantity and its % share.
Above it, there is a transparent line with the Total Quantity.
How can I replicate this in PBI?
Hi @uie07923
Have you tried the Line and stacked column chart? For the Total Quantity line, you can create a measure to calculate the total value and put this measure into the chart as a Line value to display it.
Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.
Hello @v-jingzhang and @amitchandak !
This one almost works!
The issue is that the columns must change in size according to the total quantity, and not stack to 100%
Note that it changes according to the value of the "line":
I was wondering if there is any Custom Visual for this.
Hi @uie07923
I don't find a custom visual that can meet this need. If you use a stacked column chart, you can toggle on Total labels option in Format Pane to see the total value on each column. But this chart cannot show the % share at the same time.
Regards,
Jing
@uie07923 , As far as I know, power bi shows the only labels for values used, not an additional one, so you can have one of those based on what measure you have used.
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |