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
While plotting Charts on Power BI Desktop, I am unable to see value field. On the contrary Its reflected while I try to plot Pie chart.
Please help me with this! I am totally new to Power BI
Solved! Go to Solution.
Hi @Anonymous ,
This video seems to be old. If I am right it from Year 2020. And after that Power BI has got nearly 2 years worth of monthly updates.
It looks like in current Power BI version you don't see this values section anymore. Now you see x-axis y-axis section for the chart visuals.
Also whatever you used to add in the Values section earlier, now goes to y-axis section in the latest version.
Hope this helps.
Hi, @Syndicate_Admin @Anonymous
Yes, In the current version of Power BI, the 'Values' section has been replaced by 'X-axis' and 'Y-axis' sections for chart visuals. What you previously added to the 'Values' section now goes into the 'Y-axis' section in the latest version.
If you want to access more summarization options like average, sum, or count.
First you need to, change the data type in your datasheet to whole number. Once that's done, the options will be available.
Hope this helps you.
Hi @Anonymous ,
I am not 100% sure on what you mean by: I am unable to see value field. On the contrary Its reflected while I try to plot Pie chart.
Can you please elaborate more here?
Attach some screenshot for your pie-chart visual explaining what value field you are referring here?
If I understand your question you mean why you see values section in pie-chart when compared to another charts.
Pie chart allows you to represent one metric there fore you have Values section in there.
Other charts like the one you have highlighted stacked column chart, allows you to use x-axis and y-axis to be represented. Therefore doesn't have values section. Something like below where I have shown you want to repesent Total price by date:
Thank for your Quick response 🙂 Please see the image below for Pie chart- where Value field is reflecting on right hand side. But when i try to do for Bar chart, it doesn't show value field.
HI @Anonymous
Please see my previous response with explanation please.
I am mentioning my response again here.
If I understand your question you mean why you see values section in pie-chart when compared to another charts.
Pie chart allows you to represent one metric there fore you have Values section in there.
Other charts like the one you have highlighted stacked column chart, allows you to use x-axis and y-axis to be represented. Therefore doesn't have values section. Something like below where I have shown you want to repesent Total price by date:
@Pragati11 Thanks for your response, but still my question remains that How do I add values?
Please refer to this SC as I have been following this video:
Here you can that you are able to add values in value field for Column charts.
Hi @Anonymous ,
This video seems to be old. If I am right it from Year 2020. And after that Power BI has got nearly 2 years worth of monthly updates.
It looks like in current Power BI version you don't see this values section anymore. Now you see x-axis y-axis section for the chart visuals.
Also whatever you used to add in the Values section earlier, now goes to y-axis section in the latest version.
Hope this helps.
Thank you very much I was watching a tutorial of introduction of Power BI and I could not find the field of value and I was going to give up
User | Count |
---|---|
115 | |
94 | |
87 | |
76 | |
65 |
User | Count |
---|---|
138 | |
113 | |
110 | |
98 | |
93 |