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 the data type in Power BI Desktop for this measure was General. I tried to update it to Text but for some reason the data type is not changing. Any advice on how I can change the measure data type to Text?