The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi Team,
Need help with using multiple y-axis measures or columns and a different legend column. PFB sample data.
So I would like to show negative values(Type 2) below the x-axis and positive values(Type 1) above the x-axis for categories, and when i take Category into X-axis and Value into Y-axis by default it is summarizing positive and negative values and giving the result number above the x-axis, and when i place the type column into Legend the result gets correct, but i want to place State column in legend, which is not allowed if i place 2 column or 2 measures into y-axis or if i already placed type column in legend.
and total labels should be shown both for negative side and positive side.
So basically i want a chart like below but i want my state column to be legend not type column.
Any help is appreciated.
Thanks.
Category | Value | Type | State |
A | 10 | Type 1 | New |
A | 10 | Type 1 | Old |
A | 10 | Type 1 | Unknown |
A | -5 | Type 2 | Old |
A | -5 | Type 2 | Old |
B | 15 | Type 1 | Unknown |
B | -10 | Type 2 | New |
C | 20 | Type 1 | New |
C | -15 | Type 2 | Old |
Solved! Go to Solution.
@Tutu_in_YYC , Thanks for your effort, It doesnt solve my exact purpose. However I could achieve the requirement with Deneb by considering positive and negative values as seperate layers.
Thanks.
@Tutu_in_YYC , Thanks for your effort, It doesnt solve my exact purpose. However I could achieve the requirement with Deneb by considering positive and negative values as seperate layers.
Thanks.
oh yes, deneb is a good custom visual solution. Thanks for mentioning it.