Skip to main content

Notifications

Announcements

No record found.

Customer Service forum
Answered

Power BI - Issue with Choice/Option set

Posted on by 67
I have this data in Power BI showing up as shown in the screen shot below. 
 
Please can someone help me with how to separate these values and create various dashboards with the data.
 
 
  • Brendaama Profile Picture
    Brendaama 67 on at
    Power BI - Issue with Choice/Option set
    Thank you Dengliang Li.
     
    This is a Dashboard that will be embedded in D365 CE. How can Power BI automatically apply the delimiter even after the dashboard is embedded in the CE Dashboard without any human intervention, every time a user adds a new record?
  • Verified answer
    Dengliang Li Profile Picture
    Dengliang Li Microsoft Employee on at
    Power BI - Issue with Choice/Option set
    Hi,

    It is possible to split data by delimiter. For more information on how to do this, please refer to this official document.
    https://learn.microsoft.com/en-us/power-query/split-columns-delimiter
    Publish the split data in excel form to power BI, subsequent to the process of creating dashboards you can refer to this document.
    https://www.red-gate.com/simple-talk/databases/sql-server/bi-sql-server/best-worlds-using-excel-power-bi-together/
     
    If my answer can't solve your problem, it is recommended to seek more professional help in the Power BI forum.

    Best Regards,
    Dengliang Li

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,989 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,588 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans