Added more months to display monthly trends

[sdhn]

Hello All,

I have created a dashboard based on the month of feburary.

Now I need to add data from March and April. I have 3 separate files for each month.

I want to give the options to user to select month or months or all months.

Same graphs will dispaly data for specific month or months.

Option one:

I combined all 3 files and add month column resepective to thier data.

So user can select any specific month or months.

I want that when user select any month title of report changed to that month.

For e.g:

I check on March 

Title Displays " Monthly Analysis of March"

I check Feb

Title Displays " Monthly Analysis of Feb"

I check all

Title Displays " All Month Analysis of 2021"

If I check only Feb & April , can 

Title Displays " Monthly Analysis of Feb & April"

Any recommndeation will be appreciated.  Thanks 

[CNENFRNL]

[sdhn]

Hi there,  It si working. Only one thing more, by default Title is  too  long.   Is it possible default tile shoud be as: " All Months , 2021" .   Rest is fine.  Thank You 

[v-easonf-msft]

Hi,  @sdhn 

Not very clear. Maybe you need to add a measure as below:

Measure = IF(ISFILTERED(Mths[yyyy-MMM]),_Measures[Title],"All month,2021")

Best Regards,
Community Support Team _ Eason

[Ashish_Mathur]

Hi,

Follow the steps shown in this video - Power Query #08: Import Multiple Excel Sheets From Multiple Excel Workbooks.

[amitchandak]

@sdhn , it better to merge the file in power bi and add the start or end date based on the month year.

Then use Date table to analyze the data.

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.