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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
gusdahu
Helper IV
Helper IV

Troubleshoot: Folder being used as the data source

Power BI Community,

 

I created a dashboard with data sourced from a folder located on a shared drive. The folder within the shared drive contains multiple excel documents. Each document represents a separate month (i.e. January 2018, February 2018....). Right now the folder includes all twelve months of 2018. The data feeds into a vertical bar chart on the dashboard with each month listed on the X axis.

 

Earlier today I included the population for January 2019 into the shared drive. Rather than drop the January 2018 data from bar chart, the January 2019 data appended to the January 2018 data. How may I correct this issue to show February 2018 as the first month and January 2019 as the last month on the visual? Ideally I would like to see the oldest month drop off each month as I add the latest population.

 

I hope I was able to explain my issue clearly.

 

Regards,

Gus Dahu

2 REPLIES 2
Anonymous
Not applicable

Hi @gusdahu,

 

You can create a custom monthnum column and sort the MonthYear(custom column eg. Jan-18, Feb-18,...... ,Jan-19).

While creating the custom monthnum column you can create it using SWITCH function in dax and give Feb-18 as 1, Mar-18 as 2.....

 

Workaround this, Hope once you will do , you will get clear picture.

 

Thanks,
Amit

Hi Amit,

 

Would it be possible for me to correct this issue without using a custom column? I say this because I want to be able to run the population out of my ERP system and drop it in the folder with little or minimal changes made to the actual file.

 

Regards,

Gus Dahu

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Power BI Header Change

Power BI Header Update

Read about the exciting updates for the Power BI forum.