Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have a scatter plot with Year Month and Sample ID on the X axis and some values on the Y-axis, as below.
However, I need to conditionally format values by one measure with colors and by another measure with shapes (and have more than 4 shapes) so I am testing an enhanced scatter plot and experience some problems.
1) Year/ Month - it does not allow me to choose "don't summarize" and I cannot get any timeline at all.
2) I don't seem to be able to have two measures on the X-axis as I had on the Power BI regular scatter plot.
What I have som far achieved is this, i.e. nothing.
Could anyone please help me with how I can change my setting to achieve a plot as in the first picture?
Thank you in advance!
Solved! Go to Solution.
Just to give you an update on how we solved it.
We were not able to replicate this visuals in Power BI and needed to do it right from the start: investigated the process and the need to follow and built several visuals on the theme: some lines where they could see the trend and some bars with contract numbers put on small multiples in order to follow it per contract level.
Just to give you an update on how we solved it.
We were not able to replicate this visuals in Power BI and needed to do it right from the start: investigated the process and the need to follow and built several visuals on the theme: some lines where they could see the trend and some bars with contract numbers put on small multiples in order to follow it per contract level.
Hi @Alisea_MI
To have more than four shapes, you can refer to this video Power BI Custom Visuals - Enhanced Scatter - YouTube. It starts around 6:30.
For the second question, we can only put one column in the X-axis fields. This is by design and we cannot change this behavior.
Hope this helps.
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.
Thank you, @v-jingzhang ! The enhanced scatter does not allow me to have date on the x-axis (we are converting a report from Tableau and there it is possible).
So in my case, we need to make a different front-end solution with another type of chart or several charts.
@Alisea_MI , I scatter you can get Shape with legends. I doubt two measures are allowed
Thank you, @amitchandak ! That's how I got it in the first picture. My problem with this (apart from not being able to conditionally format the color of the dots by another measure) is that I need more shapes than four standard.
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |