Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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...
Solved! Go to 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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
97 | |
75 | |
65 | |
53 |
User | Count |
---|---|
144 | |
103 | |
98 | |
85 | |
64 |