Best Approach of designing a dashboard with values like this?

[ResearchDev]

What is the best approach of designing a dashboard with values like this. Excel sheet on sharepoint. Need high level.. using Sliders and some visuals... not sure how to break up the numbered list within the columns...

[Anonymous · Accepted solution]

Hi @ResearchDev ,

According to your description, here are my steps you can follow as a solution.

First connect to the excel file in sharepoint in desktop, then click "transform data" to enter the power query editor, follow the steps below to split the row, and finally click "apply and close" to create the report and publish it to the workspace and then create the dashboard.

(1) This is my test data. 

(2) 

Note that the power query assumes that this is special text and therefore escapes it to text, so we need to manually modify the formula in the edit field.
Modify it to:

(3) Then the result is as follows.

Please refer to the following document for more information.

Split by line breaks in Power Query (excelguru.ca)

Best Regards,

Neeko Tang

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