Forum Discussion
Better visual representation
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.
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)
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.