Forum Discussion

ecroke's avatar
ecroke
Frequent Visitor
9 years ago
Solved

Filter Drop down

Hi, I am trying to recreate a column chart within Power Bi. The aspect I'm having trouble with is that I must put in a drop down box that lets you filter the chart into 5 different aspects. 1. Last...
  • parry2k's avatar
    parry2k
    9 years ago

    hey i tried to create a sample for you, see pbix file here

     

    https://drive.google.com/file/d/0B8z5lc1oML-hT3pfMVI1OE5QRFU/view?usp=sharing

     

    Basically adding some measures in calendar table and then filtered on those measures. once you have your data table related to calendar table, i expect it will filter record based on your slicer. anyhow this is an idea, you can change/amend as you see fit.

     

    Let me know how it goes. 

     

     

  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    ecroke

     

    To filter the "Last X period" data, you can create a calculated table to include all "Last X periods" dates and add a column for tagging "Last X period". Then build the relationship to existing date table to filter corresponding dates. For more details, please refer to article below:

     

    Power BI – Time Period Slicer for Last 7 Days,Last 30 Days..

     

    Regards,

v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
9 years ago

ecroke

 

To filter the "Last X period" data, you can create a calculated table to include all "Last X periods" dates and add a column for tagging "Last X period". Then build the relationship to existing date table to filter corresponding dates. For more details, please refer to article below:

 

Power BI – Time Period Slicer for Last 7 Days,Last 30 Days..

 

Regards,

  • ecroke's avatar
    ecroke
    Frequent Visitor
    9 years ago

    Thanksv-sihou-msft, I used another way of doing it but is always good to know different methods of completing it. Thanks you very much for your help.