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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
AndySmith
Helper II
Helper II

Tabular Model - unpivot equivilant (to slice report by multiple attributes)

Hi - currently I have a report connected to our datawarehouse using import method. I bring in the data the use Power Querey to manipulate the data to unpivot the table, so that the user can select from a list of multiple attributes in a report via a slicer.

We are moving to a SSAS Tabular datamodel, so I will no longer be able to perform this process. Is there a way of achiving the same outcome in the SSAS Tabular data model itself?  

1 REPLY 1
lbendlin
Super User
Super User

The combination of "Personalize Visuals"  and Field Parameters should have you covered for that.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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