Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
I need help creating a scatter plot in Power BI. I want the X axis to show months or ticket numbers sorted, and the Y axis to show a duration column I created. However, it seems that Power BI doesn't allow mixing the creation date field in the X axis with the duration field in the Y axis.
Trying to get something like this:
Can you provide any insights or solutions? Thank you in advance.
Hi @jonathanrod , if you convert your creation date data type from date-time to whole number; it will be worked.
| User | Count |
|---|---|
| 43 | |
| 35 | |
| 26 | |
| 16 | |
| 14 |
| User | Count |
|---|---|
| 64 | |
| 56 | |
| 40 | |
| 21 | |
| 20 |