The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi guys,
Need to create measure based on the "Date" filed as today & yesterday then green color , other than "Red color
Please suggest me if any idea
Regards,
Raman
Solved! Go to Solution.
I Split column LatestLastRefresh into 2 columns Date and Time.
https://drive.google.com/file/d/1kKVzzBYtQxVdyhfc6MZxLSlYY_DvsfLk/view?usp=sharing
Let me know if all good.
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Hi @Raman3456
Add a measure like this,
IF(OR(DATE[column] = today()), DATE[column] = today() - 1), "Green", "Red")
Then use the measure as conditional formating
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
HI Aj,
Thanks for the prompt reply ,
while using OR conditon in measure it is not showing the column name .
is there any other way .
Date is in Hierarchy.
Regards,
Raman
here is an example
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
I want to apply backgorund color to the date
thanks for the reply
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Every dates is coming green only
if anydate not in yesterday or today it should be red.
Thanks .
HI Aj,
Replace OR by AND
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
My requirement is ( If date=today or yesterday then Green color rest all dates should be red color ).
but as on the screeshot everything will be getting red color only .
Thanks for the support AJ.
Can you export that visual to Excel and send it to me please? I will take care of it
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
I am unable to send my file with you .
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Access has been provided
I Split column LatestLastRefresh into 2 columns Date and Time.
https://drive.google.com/file/d/1kKVzzBYtQxVdyhfc6MZxLSlYY_DvsfLk/view?usp=sharing
Let me know if all good.
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Thank you so much Aj its working fine now.
Cheers
Can't you share it on a cloud service like Onedrive, googledrive...
The URL?
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
https://docs.google.com/spreadsheets/d/1rg6NL3U4U0Ilmot9xR_FJu2l21LcXi_r/edit#gid=344102978
please go through the link
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
97 | |
80 | |
62 | |
57 |
User | Count |
---|---|
264 | |
120 | |
115 | |
83 | |
70 |