Show data as it is in source table

[NadeemAhamed]

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

[Anonymous · Accepted solution]

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]

@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