Show values of multiselect optionset from Dynamics 365 in Power BI

[pavanmanideep]

Hi Community,

I might be missing something, please help me on the below query. I need to show the data in Bar Chart in Power BI. If suppose, a case has multiple case statuses, I need to show multiple records one for each status, I had split the data in multi optionset using comma as delimiter and split that into rows. But when I check the count of records for each status, the count doesnt match. Any refereces would be helpful.

Could you suggest what I am doing wrong?

Thank you. 

[pavanmanideep · Accepted solution]

Hi @v-shex-msft 

Thank you for taking time to reply me. I was able to solve this problem using the same approach I mentioned in the issue statement.

Cheers,

PMDY

Cheers,

PMDY

[v-shex-msft]

Hi @pavanmanideep ,

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng