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.
Hi,
I have a matrix with the categories on rows (blacked out in the below image for security reasons) and the week of the year number (1..52) on the columns, with some dates in the values.
But powerBI automatically restricts the values to take the earliest date in each week, and the only other options I have are latest date or simply count of dates in each week, as part of the summarization:
But I want to display all the dates in the week (there 2/3 dates in each week that needs to come through as values).
Is this possible to do?
Thanks in advance!
Solved! Go to Solution.
@Anonymous , You can not do that in case of matrix visual
Max you can do that you create a measure
concatenatex(Table, Table[Date], " , ")
Yes. You can either use double quotes with a carriage return in between, or just use CHAR(10) in place of ",".
Pat
@amitchandak Thanks for your response.
That's unfortunate that this is not possible in PowerBI. But the work around you suggested does work.
Is there a way to use a "new line" (Similar to \n) as a delimiter in PowerBI instead of ","?
Yes. You can either use double quotes with a carriage return in between, or just use CHAR(10) in place of ",".
Pat
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
142 | |
72 | |
62 | |
51 | |
48 |
User | Count |
---|---|
206 | |
90 | |
61 | |
59 | |
57 |