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.
Hi all,
I have a table with values filtered by a standard date dimension table.
I have a date slicer setup and want to have a visual of sorts showing only the first and last date on the x-axis - instead of a continuous time series inbetween the two.
Is that possible?
Solved! Go to Solution.
Hi @donaldo ,
I will show you a workaround:
Create 2 measures as below:
Measure = CALCULATE(MIN('Table'[Date]))
Measure 2 = CALCULATE(MAX('Table'[Date]))
Create a line chart and add date and value in the visual, then turn off the X- axis :
Create 2 card visuals then put 2 measures above in it : category:off
Finally you will see:
For the related .pbix file,pls click here.
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
Thanks for the solution. Sorry for the delay in answering. Covid-19 caused priorities to change - but I'm back now.
It might be the solution I have to go with, but the request is to not have the values in between the two dates. So ideally a bar chart with only 2 points on the X-axis and only 2 correspnding Y-values. If we span enough time the line chart or whatever inbetween will be very long.
There is no way to get it to show just a MIN and a MAX value?
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 |
---|---|
112 | |
97 | |
82 | |
67 | |
61 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |