Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Data Export to Excel Not Correct

The goal is to export data which has a ratio. Problem is that the visual will correctly display the ratio but when exported, excel will generate the value as a date. The measure creating this ratio w...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    4 years ago

    I was able to find a resolution by updating the measure from " / " to " of "

    sold_inventory_ratio =
FORMAT(VALUE([item_sold]),"0,0") & " of " & FORMAT(VALUE([item_inventory]),"0,0")

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Anonymous ,

 

What is the Data Type of this column in Power BI Desktop?

Could you try changing it to Text Type then exporting again?

 

Best Regards,

Jay

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Anonymous I updated the measure and the data type is now Text. Unfortunately, I am still getting the same result for the data export. The export will result in some values reflected as Dates (just like in the example listed above). 

 

Any advice on how I can remedy this? Your advice is greatly appreciated. 

 

sold_inventory_ratio =
FORMAT(VALUE([item_sold]),"0,0") & " / " & FORMAT(VALUE([item_inventory]),"0,0")