Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
hey everyone,
I'm desperate to fix this problem below. I will share dax and screenshots as well.
It's working for 2024,25,26,27 but it's not working 2022 and 2023... interestingly It's actually filtering the selected dates when I remove dimensions from "Rows" I have no idea how this is happening, and If it's easy I want to fix my dax code, if not other approaches will be appreciated.
this is the dax function I use in the matrix view, filtered by "1"
NUMBER #1
and this filters the records between selected dates, from date - to date, here below
(bring from 2022 - Q2 to 2023 - Q2) but we don't have any dimensions in the Rows
NUMBER #2
it works after 2023 but when it comes to 2022 and 2023 it's NOT working
when I remove "Rows" it's working
NUMBER #3
It's not even working in 2022 (when remove "rows" its working)
Solved! Go to Solution.
it was filterin on table view, but i realized it was not working for MATRIX view, and i remember to not
using a filter in the table but in the measures itself. I adjusted 2 measure i used to this below. Now it's working
it was filterin on table view, but i realized it was not working for MATRIX view, and i remember to not
using a filter in the table but in the measures itself. I adjusted 2 measure i used to this below. Now it's working
@Bilhan , if you want two date/period slicer you need to follow disconneted table approch
Power BI Abstract Thesis: How to use two Date/Period slicers
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!