Forum Discussion
Customized Parameter Measure
Hi SurendraD ,
When clicking one of columns, need to show distinct values. What table is the values column in? Which fields should go in the slicer?
Could you please provide more raw data(exclude sensitive data) with Text format and desired result to make a deep troubleshooting? It would be helpful to find out the solution.
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous Sure, I have a table like below. Now i want to create a slicer which contains {"Last 7 Days, Last 5 Weeks and Last 2Month"}
Details:
Last 7 Days: This will contain the Day column (D1,D2,D3.....D7) and these need to be in distinct values.
Last 5 Weeks: This will contain the Week column (W1,W2....W5) this too be in distinct values
Last 2 Months: this will contain the Month column(Mar-24,Feb-24) this too be in distinct value.
Now, if I select the slicer, Dates need to group by with Days or Weeks or Month based on slicer options and selected (Respective) distinct values need to show in chat x axis. as give sample Chat given below
My consern is I need to check the last 7 days, Last 5 weeks and last 2 months Sales trend( with group the date by Days, weeks, Months ) in chat insted of showing all dates
Table
Sample Chat
I hope this will give you better clarity.... If any confution please text me