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.
Hello, I have a few dashboards setup with BciCalendar as below. When we open the page to view the info I want it to always show the current month on that visual whilst allowing the person navigating to view historical data (May 2018 is the oldest data in the dataset).
is that possible?
Solved! Go to Solution.
Hi @Anonymous ,
We can create a measure and use it in visual filter to meet your requiremen:
Current Month Show Control =
IF (
CALCULATE ( COUNTROWS ( 'Calendar' ), ALL ( 'Calendar' ) )
= CALCULATE ( COUNTROWS ( 'Calendar' ), ALLSELECTED ( 'Calendar' ) ),
IF (
YEAR ( TODAY () ) = YEAR ( MIN ( 'Calendar'[Date] ) )
&& MONTH ( TODAY () ) = MONTH ( MIN ( 'Calendar'[Date] ) ),
1,
-1
),
1
)
Best regards,
Hi @Anonymous ,
We can create a measure and use it in visual filter to meet your requiremen:
Current Month Show Control =
IF (
CALCULATE ( COUNTROWS ( 'Calendar' ), ALL ( 'Calendar' ) )
= CALCULATE ( COUNTROWS ( 'Calendar' ), ALLSELECTED ( 'Calendar' ) ),
IF (
YEAR ( TODAY () ) = YEAR ( MIN ( 'Calendar'[Date] ) )
&& MONTH ( TODAY () ) = MONTH ( MIN ( 'Calendar'[Date] ) ),
1,
-1
),
1
)
Best regards,
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 |
---|---|
107 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |