Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Last 4 Week filter

Hi ,   Any one please help here,   I need last 4 week to filter automatically in chart , see the below content for example.   I need individual filter to all visuals based on last week an...
Tutorial Requests
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi, Anonymous  please check the link down below.

    Please check page2, which is shown without using a tabular editor in Power BI.

    In this case, I created one more table that is for the WEEK-Variance-Non-Tabular-Editor-Table.

     

    https://www.dropbox.com/s/9dd1yerghfz9rpm/mogunase1.pbix?dl=0 

     

    Hi, My name is Jihwan Kim.

    If this post helps, then please consider accept it as the solution to help other members find it faster.

Jihwan_Kim's avatar
Jihwan_Kim
Super User
5 years ago

Hi, Anonymous 

Thank you for your feedback.

it is still possible, I think....

but I don't think I can still display different number format (dollar and non-dollar) in one visualization.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi,

Format is not a problem , but i need filter to be apply.

Possible?

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    5 years ago

    I will create a sample pbix file by using my sample.

    At this moment, I think I need to transform my original sample data to be unpivoted.

    But, I am not sure how your table looks like.

     

    • Jihwan_Kim's avatar
      Jihwan_Kim
      Super User
      5 years ago

      Hi, Anonymous  please check the link down below.

      Please check page2, which is shown without using a tabular editor in Power BI.

      In this case, I created one more table that is for the WEEK-Variance-Non-Tabular-Editor-Table.

       

      https://www.dropbox.com/s/9dd1yerghfz9rpm/mogunase1.pbix?dl=0 

       

      Hi, My name is Jihwan Kim.

      If this post helps, then please consider accept it as the solution to help other members find it faster.

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Thanks for your solution.

        Got it!

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    5 years ago

    Hi, Anonymous 

    Please check the link down below.

     

    You can refer to the Page 3.

    Related measures are in the folder name = Page3measures

    The used tables in this case are Dim-Date-Table / Main Table / Description Table / Week variance non tabular editor Table -> 2 general tables plus 2 additional tables.

     

    Just for your reference, if you use the tabular editor in Power BI, you can just use 2 general tables, and no need to create additional tables.

     

    Thank you.

     

    https://www.dropbox.com/s/9dd1yerghfz9rpm/mogunase1.pbix?dl=0 

     

    Hi, My name is Jihwan Kim.

    If this post helps, then please consider accept it as the solution to help other members find it faster.