Filterable Values from a Simple Table

[DH3612]

OK, I appreciate im a newbie in the PBI arena, but sometimes I find things I could do in excel - impossible in PBI. Hopefully this help request should be simple enoiugh for people. 

I have a simple table 

When I import to powerbi, i want to be able to show a simple visual. The visual should be a column chart. That has months along the x axis, and show a total for that month on the Y axis. However if a slicer has been selected for "Biz 2" (for example) then only show the value for that month in the y axis. 
Any ideas? 😖

[Daniel29195 · Accepted solution]

@DH3612 

in power query, unpivot your table to have the following strucutre : 

date ,  end of month , attribute ,  value 

in the attribute you will have the following values :  biz1,  biz2,  biz3 ....

NB  :  unpivot can be found under transform -->  unpivot .

you can select the first 2 columns, and use : unpivot other columns ( unpivot other columns can be find if yuo clik on the arrow near the unpivot columns ) 

let me know if this works for you .

If this answers your question  ,  mark it as the solution ✅ so can you can help  other people in the community find it easily .