Notifications
Clear all
Power Pivot
4
Posts
2
Users
0
Reactions
27
Views
Topic starter
Dear, not sure if I should ask the question in this section. I have a pivot table connected with a dataset in Power BI (analysis in excel). The column euro is text not value. How can I convert it to value? I tried with convert to , it didn't work see error message below. I tried to add formula (value) outside of the pivot table. I also get error for some rows. Can you please help out? Best is to have a solution that automatically changes, so no manual intervene every time when the data is refreshed.
Thanks!
Posted : 21/04/2022 4:31 pm
You need to do this in the Power BI model. Ideally this should be done in Power Query where you set the data types.
Posted : 21/04/2022 7:28 pm
Topic starter
Thank you Mynda for your help! The tricky part is that the dataset in power bi is connected with a direct sql query. I will have to contact IT to change this.
I was hoping it is possible to change it in the pivot table.
Posted : 22/04/2022 4:14 am
It can't be done in the PivotTable, sorry.
Posted : 23/04/2022 1:04 am