Forum Discussion
AadFourpoints
3 years agoFrequent Visitor
Simple plain fixed Constant line in bar graph, how?
Dear community, It could be a lack of knowledge or maybe I missed something critical, but just playing around with PowerBI (February 2023) and created the most simple dashboard one can think of: ...
AadFourpoints
3 years agoFrequent Visitor
Dear community,
Not knowing how to solve this issue and seeing that another report on an SQL table gives alot of options regardings lines in the Visualisation pane, I did following workaround. I created a database in SQL Server, imported this CSV file. I exported the newly created table to a flat file and when I import this flat file in PowerBI I got this Constant Line option (but no other options). I am flabbergasted, the only diference is that the new flat file has UTF-16 and the original has UTF-8. So, problem solved but with a bit of an overkill workaround if I may say so .....
Kind regards,
Aad