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...
v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft 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.