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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
pradeept
Resolver I
Resolver I

Ad-hoc or Custom Reporting

Hi all, 

I have one scenario.

Users looking for the free hand selection of Dimension and Metrics from the predefined lists.  Dimension list contains 10 dimensions and Metrics list contains 7 metrics.  User can select any type of combination and want to see the results in Table format.

 

Here is the sample requirement for this scenario. 

 

Ad-Hoc_or_Custom Reporting.JPG

 

Thanks in advance.

2 REPLIES 2
Fowmy
Super User
Super User

@pradeept 

You can allow your users to set up the dimensions and the metrics as they desire using the Personalized Visual option along with Perspective to put restrictions as well.

https://www.youtube.com/watch?v=b0kvxj_d6QQ
https://www.youtube.com/watch?v=20HwiEhIShc

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

@Fowmy 

Thanks for the resources. 

Dashboard consumers/Business users don't want to do these many steps. so I am looking for the predefined set of dimesnions and metrics in the dasboard itself.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

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.