The Values Filter By Annualrly,Quatrly And Monthly In PowerBI

In Power BI, if you want to create a filter for values such as "Annually," "Quarterly," and "Monthly," you can achieve this using a custom column or a calculated column in Power Query Editor. Here's how you can do it:

1. Open Power Query Editor:

   • Load your data into Power Query Editor by selecting "Transform Data" from the Home tab in Power BI Desktop.

2. Create a Custom Column:

   • In Power Query Editor, navigate to the "Add Column" tab and select "Custom Column."
   • In the custom column dialog box, you can define a formula to categorize your data into "Annually," "Quarterly," or "Monthly" based on your requirements.
   • For example, you can use the following formulas:
     • For Annually: if Date.Month([DateColumn]) = 1 then "Annually" else null
     • For Quarterly: if Date.Month([DateColumn]) = 1 or Date.Month([DateColumn]) = 4 or Date.Month([DateColumn]) = 7 or Date.Month([DateColumn]) = 10 then "Quarterly" else null
     • For Monthly: Text.Combine({Text.Start(Date.ToText([DateColumn]), 7), " Monthly"}, " ")
   • Adjust the formula according to your specific date column and requirements.

3. Close and Apply:

   • Once you have created the custom column with the desired values, close the Power Query Editor and apply the changes to your dataset.

4. Use the Filter:

   • Now, you can use the new custom column as a filter in your Power BI report.
   • Add a slicer visualization to your report canvas and drag the custom column (e.g., "Frequency") to the slicer.
   • Users can now select "Annually," "Quarterly," or "Monthly" from the slicer to filter the data accordingly.

By following these steps, you can create a filter for values such as "Annually," "Quarterly," and "Monthly" in Power BI based on your data's date column. Adjust the formulas and column names as needed to fit your specific dataset and requirements.