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,
I am looking for a solution where the default selection for a date in the last 30 days and at the same time slider can be changed by the viewer.
This feature is needed so when we see daily data for suppose 5 years data, the chart should look cleaner but currently, it shows the whole 5 years data and the chart looks clumsy.
Click on the slicer and under the filters pane you can customize the date to the times you want. See my picture below for reference.
@Anonymous This solution wonk work as it will freeze the date range to the selection based on the filter pane. I want it to be flexible for end-user. The only requirement is that when it loads the first time the selection of date should be last 30 days.
@amitchandak @Greg_Deckler @parry2k can you help.
@kulpowerbi Well, if you publish it that way, that will be the default. The other way to potentially do it is to get the MIN and MAX of the slicer and compare that to the MIN and MAX of ALL the table (date). Then, if the mins are equal and the maxs are equal, show the last 30 days.
Hi @Greg_Deckler This was a little tricky but I am able to achieve it by applying your suggestion. Now I have another requirement where I need to provide custom selection based on bookmark clicked. My sample PBI file
I have used drill down and bookmark to get a chart by year/month/qtr/daily.
Requirment:
When Slider is the default, and Bookmark Year clicked, then sales should be show only for custom year e.g 2015 only.
When Slider is the default, and Bookmark Qtr clicked, then sales should be show only for custom Qtr e.g QTR2 and QTR3 only.
I have written below dax, can you help me why it's not working..
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |