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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
powerbidev123
Helper V
Helper V

Better visual representation

Hi Fabric fam.

 

I needed a quick suggestion on how to better display  the below visual. The visuals currently are individual based on stacked column chart since each of the assessment,interview and other parameters are based out of calculated columns. Is it possible to show these parameters in a single chart ?

 

powerbidev123_0-1736827707983.png

 

3 REPLIES 3
danextian
Super User
Super User

Hi @powerbidev123 

You can use small multiples but  those measures need to be materialized first using a disconected table so they can be split into different categories which values refer to the measure name.

danextian_0-1736830840197.png

You can create a disconnected table using DAX or M/Enter Data. Create another measure to return the other measures based on the current row value in the column  in the disconnected table.

danextian_1-1736830876357.png

Please see the attached sample pbix (note ignore the other pages)










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


Proud to be a Super User!









"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.
Irwan
Super User
Super User

hello @powerbidev123 

 

you might be interested in Field Parameter.

Use report readers to change visuals (preview) - Power BI | Microsoft Learn

 

this will make all your visuals into one visual but axis value (interview, assessment, etc) will be changed depend on selection.

 

Hope this will help.

Thank you.

Hi @Irwan , Thanks for your reply. I think I didn't explain properly. There are calculated columns created for each Assessment,interview,physical verification etc. and not a single calculated where these values are stored.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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