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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Loubot3000
Resolver II
Resolver II

Is there a feature that allows a dashboard user to create their own cross-tabulations of the data?

Is there a feature that allows a dashboard user to easily create their own cross-tabulations of the data?

Perhaps similar to the software Q, where you have drop down menus for crossing different variables with eachother.

 

I don't think this exists, but I have to ask so that I can prove to my workplace that I know what I'm talking about and that it'd be silly to force Power BI to do something it isn't designed to do, and that we already have software to do.

1 ACCEPTED SOLUTION
MFelix
Super User
Super User

Hi @Loubot3000 ,

 

Power BI allows to have the users personalize the visualizations they are seeing, selecting not only the type of visualization but also the fields they want to see. Check if this is what you need.

 

https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-personalize-visuals?tabs=powerbi-...

 

You also have the option to connect the Power BI dataset to excel.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

5 REPLIES 5
MFelix
Super User
Super User

Hi @Loubot3000 ,

 

Power BI allows to have the users personalize the visualizations they are seeing, selecting not only the type of visualization but also the fields they want to see. Check if this is what you need.

 

https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-personalize-visuals?tabs=powerbi-...

 

You also have the option to connect the Power BI dataset to excel.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



This is exactly what I was looking for! Except actually, I realize this isn't a feature I can really use with my dataset, since it is split out by each unique user, so most of the numbers I show on the dashboard are from calculations with DAX, which the user can't do.

Thanks anyway!

Hi @Loubot3000 ,

 

If you want the user to make calculations and so on, you need to add them as contributors to the workspace that way they can do the changes to the model, that can be done using Power BI Desktop but it's also in preview the abbility to make the changes online:

https://learn.microsoft.com/en-us/power-bi/transform-model/service-edit-data-models


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Sure, but the client can't reasonably be expected to do that. They definitely wouldn't be doing that.

Hi @Loubot3000 ,

 

Didn't know that, if they want to make some interactions with the data and additional calculations only option I see is the Excel connectivity this can be done directly from Power BI service or from Excel.

https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-connect-excel-power-bi-datasets

 

It's a Pivot experience with some limitations around the calculations but it works with your models.

 

Hope i have helped giving you alternatives.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



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.

Top Solution Authors