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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
UditJ
Helper III
Helper III

Pivot Table in Power BI Desktop

Is it possible to add new dimensions in real time similar to a pivot table? 

Below is a  table chart so if we select any dimension from the top left it will get added in the filter section.  is this possible from UI or we need to edit the report to achieve this requirement? 

UditJ_0-1698640054210.png

 

2 REPLIES 2
ThxAlot
Super User
Super User

Field parameter does the trick. There are already tons of tutorials out there.



Expertise = List.Accumulate(


        {Days as from Today},


        {Skills and Knowledge},


        (Current, Everyday) => Current & Day.LearnAndPractise(Everyday)


)



FIled Parameters wont give us ability to add new dimensions in real time instead we can filter them. So when i select any dimesnion a filter/slicer should pop up

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

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

August 2025 community update carousel

Fabric Community Update - August 2025

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

Top Solution Authors
Top Kudoed Authors