March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
I am trying to use the enhanced scatter 2.0.0 (https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380762?tab=Overview) to display some values, but for the sake of visual appeal i need to custom set the start and end of x/y axis. I can't find an option for that under format pane and the closest I've gotten is the data fields X Start, X End ... . However i have tried all the different types of data i could think of in there and nothing seems to have an effect. I have tried searching for documentation and tutortials but have thus far been unsuccessful.
Solved! Go to Solution.
Hey @raulallas ,
as it seems it's only possible to set the start and end of the axis by filtering the values.
For this example I'm using the wide world sample dataset (https://github.com/microsoft/sql-server-samples/tree/master/samples/databases/wide-world-importers).
Caution: It's necessary to align the measure that filters the values and the column used in the "Details" band of the visual. The next screenshot shows unfiltered values (numeric column "quantity used" on the x-axis:
where the values on the x-axis in the next screenshot are filtered using this measure:
Total Quantity =
var xmin = 100
var xmax = 200
return
SUMX(
'Fact Sale'
, var __quantity = SUM('Fact Sale'[Quantity])
return
IF(AND(__quantity >= xmin , __quantity <= xmax) , __quantity , BLANK())
)
and the screenshot:
Hopefully, this provides some ideas to tackle your challenge.
Regards,
Tom
I was frustrated by this and found a fairly easy work-around that worked for me.
When I did this, it retained the start and end values in the enhanced scatter viz.
I hope that helps.
Amazing!!
Made my day. Incredible that there is no documentation... really hard to learn PowerBI compared to Tableau imo.
Anyways, thanks for the hint. Worked for me as well.
Hey @raulallas ,
as it seems it's only possible to set the start and end of the axis by filtering the values.
For this example I'm using the wide world sample dataset (https://github.com/microsoft/sql-server-samples/tree/master/samples/databases/wide-world-importers).
Caution: It's necessary to align the measure that filters the values and the column used in the "Details" band of the visual. The next screenshot shows unfiltered values (numeric column "quantity used" on the x-axis:
where the values on the x-axis in the next screenshot are filtered using this measure:
Total Quantity =
var xmin = 100
var xmax = 200
return
SUMX(
'Fact Sale'
, var __quantity = SUM('Fact Sale'[Quantity])
return
IF(AND(__quantity >= xmin , __quantity <= xmax) , __quantity , BLANK())
)
and the screenshot:
Hopefully, this provides some ideas to tackle your challenge.
Regards,
Tom
Hey, thanks for the tip, I tried using it, but ended up going with blank values at opposite corners of the visual for a cleaner look. However this does answer the question for anyone trying to do it so I will accept it as solution.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
90 | |
89 | |
85 | |
73 | |
49 |
User | Count |
---|---|
167 | |
147 | |
92 | |
70 | |
58 |