Forum Discussion

CLQ's avatar
CLQ
Icon for Helper I rankHelper I
3 years ago

Problem displaying data in a bar chart

Hi! I am having a problem: I have several columns (reason1/2/3/4) where there can be 4 different values, in text format: -Cold Food -Smashed Food -Rude Delivery -Other And each row represents a ...
Need Help
VijayP's avatar
VijayP
Icon for Community Champion rankCommunity Champion
3 years ago

CLQ 

In power query editor unpivot all reason columns and bring them into single column

Then try to use that in visual to get the requried visual

CLQ's avatar
CLQ
Icon for Helper I rankHelper I
3 years ago

I'm sorry, I didn't understand: if I have all the data in a single column, how would PBI recognize the four different texts and then count each one so that it looks like the graph I posted?