Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hello all,
I am struggling with problem when I try to split column By Delimiter to rows. I have one table for now.
I am trying to split Labels (and sub-scope also) column to use solo values in slicer but when I am doing it I am getting duplicated rows with other columns.
I mean when I split labels column and then I try to use Count of Market I am getting 6 instead of correct value in this case which is 3.
I would like to do split also for Sub-scope but It causes additional rows and also getting wrong values in Market count or Sum of TCV etc.
How to work with it to split these valus to use it in slicer and be able to filter with this slice all needed visuals but do not cause duplicats and wrong count/sum numbers?
Quick example on screenshot
Thanks in advance
Solved! Go to Solution.
I hope you have created relationship between the 2 tables too. If you are unable to do it, please share the sample pbix file here.
Create Primary key and Copy the Primary key and Labels to a new table and then split the values. You can use a measure to count the Market column from your main table.
Regards
Ismail
@miTutorials Could you write it in more details? How to create Primary key and copy it to another table?
In that solution I can split labels and sub-scope in one newely created table ?
Edit - I was able to find in model view how to set Key Column(This is such option, right?)
However I don't know how to copy it to new Table. I should set Primary key there also?
I set Key Column, Duplicate table and split values but When I put slicer with Values from new table there is no effect on visuals which use values from primary table
I hope you have created relationship between the 2 tables too. If you are unable to do it, please share the sample pbix file here.
After setting relationship "one to many" works as expected.
Thanks
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
75 | |
62 | |
51 | |
47 |
User | Count |
---|---|
212 | |
82 | |
61 | |
60 | |
57 |