Forum Discussion
Get distinct values and lookup count
Skilled SharerHi Krisztian
One way to do this is to unpivot columns Current Manger and Next Manager.
Go to Edit Queries, select these two columns, go to Transform tab and choose Unpivot Columns
You table should now look like this
Hit Close and Apply for changes to take effect.
From the report page, select the matrix visual and distribute your fileds as below to get the desired view
Make sure you are grouping the Employees by count.
You can always turn off the totals and change the field names.
Hope this helps!
Hi, but how do you think is it possible to put pivot on pivot, I mean if we have XX-4, XY-4, ZX -5 and put these figures on graph on x-axis and on y - axis count of current managers or next managers, like I have in the photo?
- SabineOussi
Can you please explain what the bars and line are?
Are the bars the count of employees by current manager and the line the count of employees by next managers?
So you want something like this?
Will try to exlain you in different way, step by step!
First of all, I have some data:
Order No. Product 5754305 x 5754305 y 5754305 y 5754306 yy 5754306 x 5754307 z 5754307 y 5754307 z 5754307 x 5754307 yy 5754308 x 5754308 y 5754308 y I am preparing in excel pivot and get such data:
Order Count of Product 5754305 3 5754306 2 5754307 5 5754308 3 Grand Total 13
But my goal is to make in POWER BI count of product on x-axis and count of orders on y-asis, like this:
So it means that I have 1 order with 2 items in it, 2 orders with 3 items and 1 order with 5 items
So I really want to exclude the step of making a pivot in excel, but from this data source at once make a graph like I already mentioned. Hope You can help me!:)
