Forum Discussion
Helper IVSlicer month distribution
I want to create a Slicer which will show me
1 month
2 month
6 month
9 month
1 year
1.5 year
I want to see slicer then my sales will come, I have calendar table
Hi bilalkhokar73 ,
You could create a table like below.
Use [range] as slicer and use [month] as the filter condition in the formula.
For example, calculate the max value in selected range.
max_value_in_latest_range = calculate(max([value]),filter(allselected(table),edate([date],selectedvalue(slicer[month]))>=today()))
Best Regards,
Jay
2 Replies
- amitchandak
Super User
bilalkhokar73 , You can create it using independent table and then you can switch measure based on what is selected
like measure slicer
https://www.youtube.com/watch?v=b9352Vxuj-M
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slicer-parameter-table-pattern Hi bilalkhokar73 ,
You could create a table like below.
Use [range] as slicer and use [month] as the filter condition in the formula.
For example, calculate the max value in selected range.
max_value_in_latest_range = calculate(max([value]),filter(allselected(table),edate([date],selectedvalue(slicer[month]))>=today()))
Best Regards,
Jay
