The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
We have a bar chart that shows 2 years next to each other. We would like to drill down on 1 quarter and see that quarter for those 2 years. However, when we drill down we just see the 4 quarters of one year.
Is there any way to drill down in a way that we would see the quarters of the 2 years next to each other?
Use the drill down all button and filter to QuarterNumber=X.
Drill all
We see quarters in every year. Note the filter on the visual to QuarterNumber=1
I understand how this would work in the Power BI Desktop client. But how would this work in Power BI in Office 365? I don't have those filter fields in O365????
You have to edit the report to add a page-level filter. When consuming a published report in the PBI Service, that filter will only appear if a field exists as a filter.
User | Count |
---|---|
78 | |
77 | |
38 | |
30 | |
28 |
User | Count |
---|---|
106 | |
96 | |
55 | |
49 | |
46 |