Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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 ?
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)
Proud to be a 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.
User | Count |
---|---|
134 | |
72 | |
72 | |
58 | |
54 |
User | Count |
---|---|
194 | |
95 | |
65 | |
62 | |
53 |