Forum Discussion
Power Query errors
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
This thread should help you to show blank counts:
https://community.powerbi.com/t5/Desktop/Include-count-of-blanks-in-a-chart/td-p/1648482
Pete
BA_Pete Thanks for your comment.
The problem I had was as following. My dataset wasnt consistent. For example I had the following cells (look at column AK):
So sometimes it gives a value, and sometimes an empty cell is 'empty', sometimes an empty cell is an '-'. I tried to import it at PowerBi and it was also giving errors. So that was the reason I decided to replace all 'empty cells' in my Excel to an '-'.
I also want to show empty cells in my powerbi as a graphic. For example: Column x has a filling degree of 20%. I thought it would be easiest to mark these with '-'
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