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.
I have start of the hour as a variable that I tried to use as a drill-though variable. But when I select 9:00AM on a graph and drill though to a card, it shows the time and a dummy date that I do not want. My variable is set as time variable. Any suggestions on how I can make the card show time-only?
Solved! Go to Solution.
In DAX, times also have that hidden data value (and Dates have a hidden time value of midnight). You can wrap it in format to show your desired format (or choose a format in the ribbon).
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Hi @Maureen
One of the best parctices in Power BI is to *** Split date and time *** for better performance
https://powerbi.microsoft.com/en-us/blog/best-practice-rules-to-improve-your-models-performance/
I suggest you add a new column for Time and use it in your card
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
This column was already set up as a "start of the hour" column from the query editor and shows as only a time variable, not date/time Is it still necessary to split even though it shows as time only?
I would say yes and try it if you prefer to see the exact time in your card.
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
In DAX, times also have that hidden data value (and Dates have a hidden time value of midnight). You can wrap it in format to show your desired format (or choose a format in the ribbon).
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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 |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |