Forum Discussion
Histogram Horizontal Axis Filter And Group (Double filtering)
Hi,
I am a newbi on Power BI, I need help to create a KPI filtering on two columns
I have tree columns :
| Date | Type | Status |
| 10/01/2021 | A | End |
| 11/01/2021 | B | Enrolled |
| 12/01/2021 | C | Run |
| 13/01/2021 | A | End |
| 14/01/2021 | B | Enrolled |
| 15/01/2021 | C | Run |
| 16/01/2021 | A | End |
| 17/01/2021 | B | Enrolled |
| 18/01/2021 | C | Run |
I want to make a report like the followinf image :
But I dont know what to do, to have a filter on this horizontal axis firstly by month (all months... december to january..) and by type (replicated by all months..)
Thanks for your help in advance,
Regards,
Antoine MICK
This is what I meant by drilling down:
4 Replies
- AlexisOlson
Super User
I don't think you'll be able to reproduce that visual exactly but you can get the same basic structure by putting both Type and month on the x-axis and drilling down.
Here's an example of this with the built-in stacked column chart:
Hi AlexisOlson, thanks for your reply !
I put Date and filtered by month and add Type on the X-axis but it didn't show the same view than you...
i have only the months
take a look of my view here :
can you give to me more details please ?
but it's the same view of your our position that I want ! That super 👍🏾
- AlexisOlson
This is what I meant by drilling down:
