Forum Discussion
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://toyotsu.box.com/s/mboowbzdtokv925yklhig6t8dd74uli5
When i have fetch the excel data to Power BI the Category order is getting change to Asc or Decs order.
But i need to show as it is in the excel.
I tried to create new table for the Category with Order column and Shorted by Order Number, But i am getting first category name as blank.
Thank you in Advance
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.
2 Replies
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
