Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi guys,
I'm trying to find any visual that can solve my problem (and i dont find anything). I have 3 measures:
Actual Sales. Sum of sales for each day..
Ref Sales. Sum of expected sales that i should have every day
Ratio Actual vs Ref (%)
And i want to have a visual where Actual and Ref sales should be columns and the Ratio should be a line. The visual called "line and clustered chart" not solve my problem due to it creates 2 columns (one for actual and one for ref). I have tried a visual from the market called "Bullet chart by OkViz" and the columns are in one with superposse the other but it not solve the problem of the line becasue it doesnt have the option to put a line. I have tried other things but i dont find any visual that solve my problem.
Any have the idea of a visual that can do that?
Hi @dobregon,
Maybe you can do 'unpivot columns' on 'query editor' side to convert your value fields(actual and ref) to attribute and value, then you can use 'attribute' on column series and 'value' on column value to group original values based on series category.
Regards,
Xiaoxin Sheng
@v-shex-msft thanks for your reply,
it is not the problem. i can have 2 measures or 2 columns calculated but the problem is that i want to have this type of visual (picture)
In dark grey the actual sales, in grey the expected and the line the ratio. The problem is that i cant find a visual in the market (free) thatt can do that.
The bubble chart that i said have only the posibility of the 2 columns but it is not possible to add the line. The microsoft visual line and columns chart have the possibility to do 2 measures as columns and lines but there are 2 columns (picture below, but imagine a line too)
So, i'm looking for a visual that can do that the first picture.
HI @dobregon,
If you want to display these data labels on the same column, I'd like to suggest you use 'line and stacked column' chart.
BTW, I don't think it is possible to use normal power bi visuals to show different data labels to stack them on the same axis position.
For your requirement, maybe you can try to use R visual or Python visual to manually plot a similar graph based on script/code with source table records.
Regards,
Xiaoxin Sheng
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |