Forum Discussion
How to create chart with Column based on numeric data + 2 lines based on percentage
How to create such chart http://take.ms/yZd8A ?
there no percentage in data type http://take.ms/KyF5s
Here is data which I place into Power BI http://take.ms/csjhN
When I create chart and sort by Nice it starts to look like on Excel, but only columns. http://take.ms/hhSXn http://take.ms/Tbqhh When I add line values they move to top by single straight line, not like on that example from excel http://take.ms/jRkUN
Even I simply create 100%stacked column chart
http://take.ms/dgoLX
Nazar Whenever you don't have the option to SUM and you see only COUNT - your data is DATA TYPE - TEXT
So go and change the Data Type for the 2 Line Value Columns
4 Replies
- Nazar
Helper I
Sean still not working
here is possibility to change Sum to count http://take.ms/NqMVX
but for those two values there no such possibility http://take.ms/5aGec
here I notice you have such icon http://take.ms/h2Zvy near that line values
also here Sum option is disabled for these columns http://take.ms/1Hf3t with %