Forum Discussion

Neok's avatar
Neok
Frequent Visitor
3 years ago
Solved

Power Query errors

Hi all,   I'm trying to put in a dataset but im getting errors. I optimalized my dataset to put in all the empty fields an '-'.  The following error is coming up. It has to do something with the d...
Need Help
Show and Tell
Tips and Tricks
  • BA_Pete's avatar
    BA_Pete
    3 years ago

     

    You're better off removing all the '-' from the source. Power Query works only on raw data and data types, it doesn't really understand presentation formatting like this.

    If you really want to display '-' instead of blanks in reporting (it's not a standard thing to do) you can paste a new format pattern in here, using the same pattern structure that Excel format patterns use:

     

    Pete

Neok's avatar
Neok
Frequent Visitor
3 years ago

BA_Pete Thanks a lot it worked 🙂

 

Next question is the following:

I got fields with a lot of empty cells, its marked as '(Leeg)'. How can i show them in my graphic?