Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi everybody,
When trying to delete hierarchy date filtering with ALLSELECTED in a matrix with date(rows) and Countries(columns), first hierarchy level (year) works well but the other (quarter, month, day) don't delete their filter although using multiple columns in ALLSELECTED. How could I solve it? Thanks a lot for your help !!!.
(Figures not in bold should match the total column ones)
Solved! Go to Solution.
@Syndicate_Admin
También debe agregar las columnas [MonthNo] y [QuarterNo]
(Aunque no los veas en el visual se utilizan en la consulta que lo crea para que los meses y trimestres se ordenen correctamente)
@Syndicate_Admin
También debe agregar las columnas [MonthNo] y [QuarterNo]
(Aunque no los veas en el visual se utilizan en la consulta que lo crea para que los meses y trimestres se ordenen correctamente)
Thanks a lot, I was convinced it should be easy but don't found it. You helped me.
De nada. Con gusto.
¿Podría por favor marcar esto como una solución? 🙂
Gracias
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
2 | |
1 | |
1 | |
1 | |
1 |
User | Count |
---|---|
2 | |
2 | |
2 | |
2 | |
1 |