Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello everyone,
Solutions | Regions | Year |
Solution 1, Solution 2, Solution 3 | Region 1 | 2022 |
Solution 1, Solution 2 | Region 2 | 2023 |
Solution 3, Solution 2 | Region 3 | 2022 |
Solution 1, Solution 4 | Region 1 | 2023 |
I would like to see if there is a possibility to do the following:
I would like to have an additional table with just the Solutions and counter on how many times certain Solution X appears.
However i would like to have multiple several dashboards, where I can filter Years or Region, and by filtering those I will get different values, like for example:
Solution | Number |
Solution 1 | x |
Solution 2 | y |
Solution 3 | z |
Solution 4 | u |
x,y,z,u - are the number of appearances of Solutions in Column Solution based on the filter you use.
View 1: I filter on the page Region 1, and then i can plot Bar Chart that is going to show me in Region 1 count of Solution 1/2/3/4.
View 2: I filter on the page Year 2023, and i can plot Bar Chart that is showing me only for Year 2023 representation of how much Solution 1/2/3/4 appeared.
However i am aware that this is hard to implement as multiple filters on multiple pages can make a mess in column. I would like to hear your ideas and suggestions. I know that i can create new columns for each filter option, but since i have multiple Years and multiple Regions, this would mean that i need to make many different columns.
Thank you for your advices in advance.
BR.
Solved! Go to Solution.
Using Power Query, I would split the Solutions column into rows:
Then trim the leading space in Solutions and you'll have data that is easier to use:
Proud to be a Super User!
Using Power Query, I would split the Solutions column into rows:
Then trim the leading space in Solutions and you'll have data that is easier to use:
Proud to be a Super User!
Seems like an great idea. However would it be possible to split column into rows but in another Table as i want data in this table to stay the same.
Sure, you can create a second table in Power Query. Right-click the query and select "Reference", and the new query will point to the original query. Apply the steps above to the new query.
Proud to be a Super User!
User | Count |
---|---|
88 | |
74 | |
69 | |
65 | |
58 |
User | Count |
---|---|
106 | |
97 | |
76 | |
63 | |
60 |