Forum Discussion
David-CF
6 years agoRegular Visitor
Newbi needs help with simple bar graph
Hi All Apologies if this is a double up - I tried to post it 3 times now before but it keeps crashing. I have a data set like this: Name Total Due Dec Nov Oct Pre-Oct Customer 1 $1,019...
Washivale
6 years agoResolver V
Hi David-CF
Per your screenshot, if this is your raw data, do following transformation and create a bar graph.
1. go to Edit Query - Select Customer Name Column - Use Unpivot other columns from Transform tab - Unpivot Columns
2. use Rename Attribute column if you want to
3. Close and Apply the power Query window
4. Add Bar graph visual on your report page. - attribute/renamed col in axis value column in values
5. create a tooltip page as instructed on below link.
https://docs.microsoft.com/en-us/power-bi/desktop-tooltips
this should get you what you trying to achieve, let me know in case of any questions.
Thank You,
Washivale
- David-CF6 years agoRegular Visitor
Thank you for your help - I'll give it a try.