Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
AllanBerces
Post Partisan
Post Partisan

Visual Base from Current Date

‎03-21-2024 11:44 PM

Hi Good day

Can anyone, pls need help how can can dislay in Visual Card the current %Daily Plan and %Actual Plan. 

%Daily Plan - Measure

%Actual Plan - Measure

Date - Date Table.

AllanBerces_0-1711089846596.png

 

Thank you

Labels:
Message 1 of 3
209 Views
0
1 ACCEPTED SOLUTION
Uzi2019
Super User
Super User

‎03-22-2024 01:16 AM

Hi @AllanBerces 
Just take same table but write a column dax for Today() function.
Today=  if('Test1'[Date]=TODAY(),"Today",""&Test1[Date])

 

and take this column value in visual filter and select only today. 

Uzi2019_0-1711095325311.png

 

I hpe this would resolved you issue.

 

 

 

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

View solution in original post

Message 2 of 3
188 Views
0
2 REPLIES 2
Uzi2019
Super User
Super User

‎03-22-2024 01:16 AM

Hi @AllanBerces 
Just take same table but write a column dax for Today() function.
Today=  if('Test1'[Date]=TODAY(),"Today",""&Test1[Date])

 

and take this column value in visual filter and select only today. 

Uzi2019_0-1711095325311.png

 

I hpe this would resolved you issue.

 

 

 

 

Don't forget to give thumbs up and accept this as a solution if it helped you!!!
Message 2 of 3
189 Views
0
AllanBerces
Post Partisan
Post Partisan
In response to Uzi2019

‎03-23-2024 12:12 AM

Hi @Uzi2019 

Thank you very much.

Message 3 of 3
179 Views
0

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

View All