Presentation of multiple choice fields in Power BI

[etnhar]

In a deviation solution, user can categorize deviations by Type of error (Type feil) and this field is a multiple choice field.

We want it presented in Power BI as accumulated number on each value in the multiple field.

Any idea? 

[v-robertq-msft · Accepted solution]

Hi, @etnhar 

According to your description and sample picture, it seems that the reason why the type “Emballasje” can appear both with Level1 and Level2 is that your original data has the value “Emballasje” after the “,” before the “Split column” operation:

Therefore, I think there are two ways to solve this problem in the Power BI.

First is to simply use the “Replace values” operation to repalce the error value manually:

Another is to create a calculated column to replace the column [Type feil.2], which is more intelligent:

Column 2 =

IF([Type feil.2] in SELECTCOLUMNS(ALL('Table'),"1",[Type feil.1]),[Type feil.2],BLANK())

And you can get what you want.

You can download my test pbix file below

Thank you very much!

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[etnhar]

Hi again, That helps, thank you. but then i run into next question.

In one Deviation 'Emballasje' can be saved in first colomn off the split(Level 1), and in another deviation in secound colomn 'Level 2' of the split.

Best would be to get same option (Emballasje) always in same colomn, so user always can see summary of error types.

Any idea?

[amitchandak]

@etnhar , Based on what I got. You can split the column into rows using delimiters 

https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/

or refer my video: Split Column Power Query: https://youtu.be/FyO9Vmhcfag

[etnhar]

Thanks, i will test and get back to you