Forum Discussion
Solved
Show 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.
NadeemAhamed , 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