Forum Discussion
NadeemAhamed
Helper V
Helper VShow data as it is in source table
Dear Community, Good Day. I have created report in Power BI. I am failed to show the data values as it is in source table. I have attached the Pbix for your reference. https://toyot...
Hi NadeemAhamed
Based on the pbix you have offered, I found that you original data has a value called Gross Profit Rate (Gross Profit/Sales), but in your Catrgory table, it called Gross Profit Rate, the two values are different, so it casued the blank value. I changed your value in Category table to Gross Profit Rate (Gross Profit/Sales), now it can work.
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
amitchandak
Super User
Super UserNadeemAhamed , Blank category means a missing value on the dimension or fact side, Check out what is missing value of where you have blank in category join