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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
HassanAshas
Helper V
Helper V

How to Dynamically add Slicers on a Report based upon the Columns in the Dimension Table

Hi, I have a Dimension table of Employees like this, 

 

Emp_IDEmp_NameCompetencyDepartment
1HarisData & IntegrationAI
2JackData & IntegrationData
3JohnData & IntegrationData
4AliceDevelopment

Web

 

Based upon that, I have added two Slicers on my Report by the name of Competency and Department. 

My current Report looks like this, 

 

HassanAshas_0-1691161065732.png

 

 

What I am trying to understand is it is possible that in future, a new column gets added into my Dimension Table. For example, a new column by the name of Practice is added in my Dimension table and my Dimension table now looks like this, 

 

Emp_IDEmp_NameCompetencyDepartmentPractice
1HarisData & IntegrationAIML
2JackData & IntegrationDataData Engineering
3JohnData & IntegrationDataReporting & Analytics
4AliceDevelopmentWebNodeJS

 

 

Is there any possible way to automatically/dynamically add the Slicer for this newly imported Column in my Report. For example, once the Power BI receives this new column into its dataset, my report should automatically have a slicer for this Column like the following picture, 

 

HassanAshas_1-1691161159514.png

 

 

Is this somehow possible to do so in Power BI? 

 

If you would like to download the Sample Power BI File, you may do so from here: https://drive.google.com/file/d/1bFuMDM8JoQFALF3qWEGJDAwWrvIy15un/view?usp=sharing

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @HassanAshas ,

 

Unfortunately power bi desktop does not support this feature at the moment.

 

If you would like to suggest  feature improvements, you may  vote the idea and comment here to improve this feature. It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

 

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

View solution in original post

1 REPLY 1
Anonymous
Not applicable

Hi @HassanAshas ,

 

Unfortunately power bi desktop does not support this feature at the moment.

 

If you would like to suggest  feature improvements, you may  vote the idea and comment here to improve this feature. It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

 

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.