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 am trying to put the date as a KPI. Basically if a filter is on a date, then the date should be shown as a big text in the dashboard header. Unfortunately, it shows a #0.00 whenever i filter on the date.
This is the formula:
Date filter = IF (
HASONEVALUE ( DimDate[Date] );
VALUES(DimDate[Date]) ;
"YTD Cumulated"
)
Cheers
Solved! Go to Solution.
Hi @alxmti,
The question you are getting is that you have two format in your final result so the KPI only returns one type in this case Number you need to change your formula to something like this:
Date filter = IF ( HASONEVALUE ( DimDate[DAte] ); FORMAT ( VALUES ( DimDate[DAte] ); "dd-mm-yyyy" ); "YTD Cumulated" )
Format the date part as best fits your needs
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @alxmti,
The question you are getting is that you have two format in your final result so the KPI only returns one type in this case Number you need to change your formula to something like this:
Date filter = IF ( HASONEVALUE ( DimDate[DAte] ); FORMAT ( VALUES ( DimDate[DAte] ); "dd-mm-yyyy" ); "YTD Cumulated" )
Format the date part as best fits your needs
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Portuguêsthanks! something as easy as FORMAT 🙂
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |