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.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

I need the same exactly what you shown , but without using tabular editor.

 

Is this possible?

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.

    • 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.