Forum Discussion

SurendraD's avatar
SurendraD
Frequent Visitor
2 years ago

Customized Parameter Measure

Hi All,

I have a table as below, I am trying to create a customized parameter. date table has relationships with other tables (One to many)
1.>slicer like:
Last 7 Days: Day column without blank.
Last 5 Weeks: Week Column without blank.
Last 2 Months: Month Column without blank.
when I click one of these respect columns needs to show distinct values only which can be added to the chats axis so that I can change the x-axis ( sample Chat mentioned below ) as I click the slicer.


Table:


Sample Chat



2.> I am trying to consolidate three column as on measure (Day,Week and month) so that those three columns will come like below.
Result:

this I am going to add in chat x axis 

 
cstan power daxdaxdax daxdax 
Anonymous  Please help me to resolv this two issues. I have tried all resources and finaly i choose this platform.




 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.

    • SurendraD's avatar
      SurendraD
      Frequent Visitor
      2 years ago

      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