Forum Discussion

NadeemAhamed's avatar
NadeemAhamed
Helper V
2 years ago
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...
General Comment
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.