Solved: dropdown list in a row

JacekStolarski · ‎08-29-2019

I connected power bi to sharepoint list with multiplay choses. I AM looking for three jest way to make a chart off this. I tried to divaide into rows but its mess up other statistics for example count of rows which is immportant. Plz help

ImkeF · ‎08-29-2019

Hi @JacekStolarski ,

I'd recommend to reference that query and create a new table where you expand that column to new rows. Make sure to keep the key column in that table to connect that table with your original table in the data model.

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

View solution in original post

ImkeF · ‎08-29-2019

Hi @JacekStolarski ,

I'd recommend to reference that query and create a new table where you expand that column to new rows. Make sure to keep the key column in that table to connect that table with your original table in the data model.

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries