Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello,
I have a data for a contractor, project,, Project type, actual progress and date
The date I have for four months Jan, Feb, March, April then I have actual progress percentage for each project and next to it the contarctor. I want to create a scatter chart which I can play the months and in the x axis will show the projects names, and the y axis shows the progress to play how much progress the contractors are doing over time. When I try to build the chart I get the followin
The problemthat I am experiencing is that on my powerbi desktop, the details facility does not exist.Can anyone help me?
The X and Y values need to be numeric in a scatterplot.
Hope it helps.
Kind regards Steve
Proud to be a Super User!
Awesome Keyboard Shortcusts in Power BI, thumbs up if you like the article
My Community Blog Articles (check them out!)
My Blog - Power M code to automatically detect column types -
How to create test data using DAX!
Hi,
Since the scatterplot any accepts 2 numeric values, one for the x-axis and one for the y-axis. You are probably looking for a different (custom) chart like, 'Animated Bar chart race', which animates bar charts. As seen below:
Power BI file
Hope it helps. Pls mark as solution if so, thumbs up for the effort appreciated.
Kind regards, Steve.
Proud to be a Super User!
Awesome Keyboard Shortcusts in Power BI, thumbs up if you like the article
My Community Blog Articles (check them out!)
My Blog - Power M code to automatically detect column types -
How to create test data using DAX!
I wanted something like the video attached but instead of total sales it will show the projects name and instead of sales units it will show the progress ...
In that case you need to create an artificial x-value:
Then you can play the results for the y-value, colour by project name.
Link to Power BI file here.
Please mark as solution if this helps you. Thumbs up for the effort are appreciated.
Kind regards, Steve.
Proud to be a Super User!
Awesome Keyboard Shortcusts in Power BI, thumbs up if you like the article
My Community Blog Articles (check them out!)
My Blog - Power M code to automatically detect column types -
How to create test data using DAX!
Please let us know if this works for you.
Proud to be a Super User!
Awesome Keyboard Shortcusts in Power BI, thumbs up if you like the article
My Community Blog Articles (check them out!)
My Blog - Power M code to automatically detect column types -
How to create test data using DAX!
Too bad, I see month is a text value and not a number btw.
Proud to be a Super User!
Awesome Keyboard Shortcusts in Power BI, thumbs up if you like the article
My Community Blog Articles (check them out!)
My Blog - Power M code to automatically detect column types -
How to create test data using DAX!
The date column is a text field? These cannot be played. Can you make it a date or a number?
Proud to be a Super User!
Awesome Keyboard Shortcusts in Power BI, thumbs up if you like the article
My Community Blog Articles (check them out!)
My Blog - Power M code to automatically detect column types -
How to create test data using DAX!
@stevedep it is date
You can experiment your self if you make a simple table with three columns, project name, date, progress and just try it for two months it wont even work
I just need to play the progress of each project by month
Hi @Anonymous ,
Try to show like this:
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for your replay. If I want to show it the same way as you suggested then I will lose the biggest benefit of the scatter chart which is showing the progress changes over time through the play axis.
The three axises that I need are:
The project name x axis
The progress percentage on Y axis
The month on the play axis.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
89 | |
84 | |
76 | |
64 |
User | Count |
---|---|
136 | |
111 | |
98 | |
97 | |
92 |