Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper V
Helper V

Quarterly data from monthly data

Hello All,


I have a table where I am having data like below and I am having 20 measures.

I have my daily ,weekly and monthly data coming from table directly.

So I need to calculate quarterly in reporting side.


Since my trendtype column not having quarter value from db side so I created a table in power bi to show daily ,weekly ,monthly and quarterly values. and put in a slicer

Lets say if user selects trendtype as daily then daily data.

weekly then weekly data,

Monthly then monthly data

and qtly then qtly data.


I am not sure how to create a logic for quarter and show the quarter data when user selects quarter in the slicer

Could any one please help how to do

Below is my sample data






Super User
Super User

@Sathvik123 , Use an independent table with values week, month Quarter etc.


and the switch calculation based on selection



"Weekly", [Week Measure],

"Monthly", [Month Measure],

"Quarterly", [Quarter Measure]



Same as the old measure slicer approach:How to create a Measure Slicer:



if you have separate measure already explore field parameters



Power BI Field Parameters — A Quick way for Dynamic Visuals:
Power BI Field Parameters- Measure Slicer and Axis/Dimension slicer:

Helpful resources

Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.