Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All. I am very new to Power BI and it's probably a very basic question.
I'm trying to create a column chart with two columns, on with name sof items and anotehr with the prices for each. However, when I drag the prices column to the y-axis it give sme a COUNT instead of displaying the actual values for the prices. I'm just not able to find a solution to this!
Your
Solved! Go to Solution.
thank you.
If there is only one price per item (based on your graph this is not the case) ... then on visualisations pane and on y-axis, click on drop down arrow and instead of count select MAX or AVERAGE
Image below
I just want a column with names of bags (x-axis) and a column with the prices of each bag (y-axis). I used the don't summarise option but still no luck.
thank you.
If there is only one price per item (based on your graph this is not the case) ... then on visualisations pane and on y-axis, click on drop down arrow and instead of count select MAX or AVERAGE
Image below
I removed duplicates and the still I don't see the don't summarise option. So I had to pick an option and when I choose average or max, it gives me the correct values. I just don't understand why I still need to choose from these options rather than simply use the exact values.
That's because these graphs show aggregated metrics otherwise on large datasets they wouldnt be able to show all values
Hello @sumaiya ,
What information are you putting on x and y axis?
can you show an example on Excel of how you want the chart to look like?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
106 | |
87 | |
75 | |
66 |
User | Count |
---|---|
125 | |
114 | |
98 | |
81 | |
73 |