Better visual representation

[powerbidev123]

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 · Accepted solution]

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.

[danextian · Accepted solution]

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.

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.

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

[Irwan]

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.

[powerbidev123 · Accepted solution]

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.