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.
Name | Skills |
Mahesh | Power BI, Cognos, Tableau |
Saravan | Tableau, Cognos |
Raju | Power BI, MSBI |
Nagesh | MSBI, Tableau |
Ravi | Tableau, Power BI |
Requirement is to know get the number of users having the each skill Power BI , Tableau, MSBI, Cognos. Need to be shown data in bar char or Pie chart
Solved! Go to Solution.
Hey @Anonymous ,
here you will find a pbix that contains a solution that does rely on data modeling instead of using DAX: https://tommartens-my.sharepoint.com/:u:/g/personal/tom_minceddata_com/EZ1UYqubNL5OrQP-VIdgBEsBF93buB8kEzbOZhVW35sslA?e=Zj62yj
I created a second table using Power Query that looks like this:
Then I creatd a Many-To-Many relationship between both tables like so:
This data model allows to create the visuals you mentioned:
Hopefully this provides what you are looking for.
Regards,
Tom
Hi @Anonymous ,
You could use split the "Skills" column and unpivot new columns in the query editor.
Then use "trim" to remove blank value.
Here is the result.
Here is my test file for your reference.
Hey @Anonymous ,
here you will find a pbix that contains a solution that does rely on data modeling instead of using DAX: https://tommartens-my.sharepoint.com/:u:/g/personal/tom_minceddata_com/EZ1UYqubNL5OrQP-VIdgBEsBF93buB8kEzbOZhVW35sslA?e=Zj62yj
I created a second table using Power Query that looks like this:
Then I creatd a Many-To-Many relationship between both tables like so:
This data model allows to create the visuals you mentioned:
Hopefully this provides what you are looking for.
Regards,
Tom
@Anonymous,
Please check this DAX function - https://docs.microsoft.com/en-us/dax/containsstring-function-dax