Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi to all,
I have 5 products and I would like to plot on a scatter/buble chart the estimated time when each of them will hit the specific revenue target (i.e.: for product 1, the estimated date is 15/04/2021, for prod.2 the estimated date is 28/04/21 etc). The Y-Axis could for example be the rolling product revenue while, if necessary, the buble dimension could be the target.
I used a simple scatter chart, with a column "Products" and a measure "Estimated.Date.Target" which has the estimated dates of reaching the target, per products.
However, as soon as I droped "Estimated.Date.Target" on "X Axis", I had the following error message:
I tried also using other scatter/buble visuals but I always had problem in showing what I have in mind!
Can anyone help me?
Thanks a lot in advance!
G
Solved! Go to Solution.
Hi @gunicotra ,
Seems like the Estimated.Date.Target is a measure, including measure [Time.Target] and measure [MaxDate].
In Scatter chart, measure could not be put in X-axis, the X-axis must be a meaningful column, not a measure.
You can try to convert all your measures to calculated columns and then put it in the X-axis.
In addition, I have noticed that you used VALUES() in the formula, if you have different year values in [Year] column, the visuals would still get error.
Supposing the max date is calculated for each year, you can create the column like this:
MaxDate = CALCULATE(MAX('Table'[Date]),ALLEXCEPT('Table','Table'[Year]))
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@gunicotra Scatter visual can only have one axis taken an unsummarized measure that is x-axis. Assuming y is already a number.
Can share the formula for measure Estimated.Date.Target
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Hai amitchandak!
sure:
Hi @gunicotra ,
Seems like the Estimated.Date.Target is a measure, including measure [Time.Target] and measure [MaxDate].
In Scatter chart, measure could not be put in X-axis, the X-axis must be a meaningful column, not a measure.
You can try to convert all your measures to calculated columns and then put it in the X-axis.
In addition, I have noticed that you used VALUES() in the formula, if you have different year values in [Year] column, the visuals would still get error.
Supposing the max date is calculated for each year, you can create the column like this:
MaxDate = CALCULATE(MAX('Table'[Date]),ALLEXCEPT('Table','Table'[Year]))
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi! perfect thanks. Your solution worked for me 🙂
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
89 | |
86 | |
75 | |
69 | |
68 |
User | Count |
---|---|
220 | |
128 | |
117 | |
82 | |
77 |