Visualization with 3 fields

[imuharram]

How can I create a visualization having 3 fields and one value to count. In my case, i have month, analyst, interval, and the value to be calculated is count

I was able to do it in excel using pivot table and chart. However, I'm not getting the same chart on Power BI. I don't want to use a slicer to filter out each field individually, I need to see all fields at once.

[vanessafvg · Accepted solution]

@imuharram not quite sure i understand what you asking

at the drill down in your chart ie. top left of your power bi chart, there is a down arrow, two down arrows, and then a expanded double arrow, click the expanded double arrow, is that what you asking for?

[imuharram]

Yes, this is what I was looking for. Thank you

However, it still looks better on excel chart, whereit has the month as a seperate block with its own label, then drills down to the second level seperatly. In power bi, it combines the two labels together where it becomes too long and have them all in one row

Power bi

Excel