Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi All,
I am a new learner of Power BI desktop. I have created 3 measure here.
1. Average Retail Price =
But when I am adding values there the catagory names are varnshing. Can anyone help me on this please?
Solved! Go to Solution.
Hi,
Correct the relationship
Hi @Saroj_kumar,
It seems like the category values might be disappearing because the measures you are trying to display may not have any values for their corresponding categories. That's the default behaviour of Power BI.
Could you try using the "Show Items with no data" option to see if the categories are populating?
Let me know if this does not work and I'll try to help.
Proud to be a Super User! Regards, Bipin Lala | Business Intelligence Developer | |
Thank you so much for the solution.
Can you guide me, I have selected as you shared. But the for each accessory is not coming.
Hi,
The fields are being dragged from the wrong tables. To receive further help, share the download link of your PBI file with the visual already created there.
Hi Ashish,
Thank you for the response. I have been stuck since Saturday and have not been able to move forward. I am not sure what I did wrong here. The Google Drive download link I am attaching here. Let me know if you can help me on this.
https://drive.google.com/file/d/1GGb_pnXG_owouk8kRogAw-lJJLqeOkOO/view?usp=drive_link
Hi,
Correct the relationship
Hi Ashish Sir,
Thank you so much.
It got resolved. I can work on this now.
You are welcome.
Hi @Saroj_kumar,
Seeing the data, it looks like you are using the Adventure Works Dataset in Power BI. That's the same dataset I had used while learning Power BI!
I am not completely sure why the measure values for categories are not populating for you, but there can few reasons for that -
It seems like we are using the exactly same Adventure Works dataset, because I found the original PBIX file I had created years ago when I was learning Power BI, and I get almost the same values in the table visual as yours
Let me know if you manage to resolve the issue or if you need further assistance. Feel free to share your PBIX file, and I'll do my best to help you out.
Proud to be a Super User! Regards, Bipin Lala | Business Intelligence Developer | |
Hi Bipin,
Thank you for your response.
I am hoping, I have done wrong relationship.
Please find the below screenshot. Let me know if I have done any wrong here.