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
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
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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