Forum Discussion
Line and Column Cluster chart
I am doing a datacamp course using PowerBI desktop.
I tried to assign data to the line y-axis but I was unable to drop the data into the space.
I tried to click on the cell to see if it held and allowed me to drop the data into the space without success.
Please advise.
Thanks for the reply from DatawithDinesh , please allow me to provide another insight:
Hi, te7037
Regarding the issue you raised, my solution is as follows:
Make sure that the data you're trying to assign to the y-axis is a number. PowerBI requires numeric data for the y-axis in the line chart. In particular, when the field you want to drag in belongs to a measure, and the return value of the measure is a Boolean value, a date, and a text, it is not possible to drag in the line y-axis.
Of course, you can also check that your PowerBI Desktop is up to date. Sometimes, bugs are fixed in newer versions.
Here's the version number I'm using:
It is recommended that you try to upgrade the version according to your needs to see if this can solve the problem, the following is the official link:
Download Microsoft Power BI Desktop from Official Microsoft Download Center
Of course, if you have any new ideas, you are welcome to contact us.
Best Regards,
Leroy Lu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- I found the solution: I need to switch the ribbon on top of the dashboard that contains the sub tools in order to hide it so that the section for the data fields is visible for data dropping.
The photo below shows the ribbon being present before it is hidden:
After the ribbon is hidden:- I found the solution: I need to switch the ribbon on top of the dashboard that contains the sub tools in order to hide it so that the section for the data fields is visible for data dropping.
5 Replies
Thanks for the reply from DatawithDinesh , please allow me to provide another insight:
Hi, te7037
Regarding the issue you raised, my solution is as follows:
Make sure that the data you're trying to assign to the y-axis is a number. PowerBI requires numeric data for the y-axis in the line chart. In particular, when the field you want to drag in belongs to a measure, and the return value of the measure is a Boolean value, a date, and a text, it is not possible to drag in the line y-axis.
Of course, you can also check that your PowerBI Desktop is up to date. Sometimes, bugs are fixed in newer versions.
Here's the version number I'm using:
It is recommended that you try to upgrade the version according to your needs to see if this can solve the problem, the following is the official link:
Download Microsoft Power BI Desktop from Official Microsoft Download Center
Of course, if you have any new ideas, you are welcome to contact us.
Best Regards,
Leroy Lu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello te7037 if you can share some pictures of what you are trying to achieve that would help us solve the issues easier.
- I found the solution: I need to switch the ribbon on top of the dashboard that contains the sub tools in order to hide it so that the section for the data fields is visible for data dropping.
The photo below shows the ribbon being present before it is hidden:
After the ribbon is hidden:Hi,te7037
We are very glad to know that the issue has been resolved. If you wish, consider accepting your solution as a solution that will also benefit other community members who have the same problem as you and find a solution faster.
Of course, if there is anything else we can do for you, please do not hesitate to contact us.
Looking forward to your reply.
Best Regards,
Leroy Lu
Done!
- I found the solution: I need to switch the ribbon on top of the dashboard that contains the sub tools in order to hide it so that the section for the data fields is visible for data dropping.
