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
MarkusEng1998
Resolver II
Resolver II

Pivot table with a slicer and the global average.

Many thanks to Liu Yang for solving my problem using a slicer to filter a record with a global average: https://community.powerbi.com/t5/Desktop/Dashboard-to-compare-Vendor-to-Global-Average/m-p/2851735/t...

 

The second request is to use the same vendor slicer to filter out a single vendor, but to also compare to the global average in a bar graph. The difference from the issue above, is that vendors are columns, not rows. Although the data source originally has the the vendor name in rows, not columns. I transformed the table so that the criteria show up in the x-axis in the bar graph.

VendorSlicer2.jpg

 

 here is the query.

VendorSlicer2b.jpg

 

 

 

2 REPLIES 2
MarkusEng1998
Resolver II
Resolver II

I would like the slicer to select which vendor column to include in the bar graph. If the slicer changed to "Walton," then then the [Walton] column would display compared to the [Global Average].

 

VendorSlicer2c.jpg

 

v-luwang-msft
Community Support
Community Support

Hi @MarkusEng1998 ,

Is it possible to describe the results you are trying to get based on the model in the previous post, in the reply?

 

Best Regards

Lucien

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.