Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
Hi,
I am trying to get a table user requested , but with my table struture i am not getting table requested, I attached a sample pbix file for review.
I am getting the table as shown below.
What I would like to do is below
| JAN | FEB | MAR | |
| Actuals | 228 | 319 | 511 |
| Target | 220 | 220 | 220 |
| %vs Ops | 103.60% | 145.00% | 232.30% |
Can someone give some hints on how can I do this.
For some reason I don't see option to attach Pbix file so I uploaded to box.https://app.box.com/s/i03baq7yxz3r9iuj1zmokindzi6nq6ph
Thanks
Suresh
Solved! Go to Solution.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsRegards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThanks Felix,
I did not know option of Show on rows, that solved my issue . I tried Matrix but could not get it right , I know I could find solution here always
Thanks a lot.
Suresh
| User | Count |
|---|---|
| 59 | |
| 47 | |
| 31 | |
| 18 | |
| 17 |
| User | Count |
|---|---|
| 77 | |
| 66 | |
| 46 | |
| 22 | |
| 22 |