Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have a standard date table and added columns to display Quarter, Quarter-Year, and then a Date Sort Column with the dax formula:
Date sort column is removed but still multiple rows for "Q4"
It makes sense that when the date sort column is added to visual to have more than 1 row because the values are different. I'm not sure why Qtr-Year would cause this. Any insights? I need to use the column to show trending data across different years.
Solved! Go to Solution.
Is the date sort column used to define a custom sort of this visual?
If so, this implies that the granularity of the visual includes this dimension, even if the sort column is not visible.
Giuseppe
Yes I use the date sort column to sort other columns such as Qtr-Year. With what you are saying, I need a calculated sort column that uses quarter instead of month. That way it will have the same granularity..
@negbc is Qtr-year column sorted by another column? Can you remove that sorting and then check?
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Yes, it is sorted by the Date Sort Column, if not the Qtr-Year column doesn't go chronologically as shown below
Is the date sort column used to define a custom sort of this visual?
If so, this implies that the granularity of the visual includes this dimension, even if the sort column is not visible.
Giuseppe
Yes I use the date sort column to sort other columns such as Qtr-Year. With what you are saying, I need a calculated sort column that uses quarter instead of month. That way it will have the same granularity..
@negbc the % you are showing in the visual, is it a column or a measure?
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
A measure, the rest are calculated columns from the date table.
Can you attach pbix with dummy data to debug this ?
User | Count |
---|---|
77 | |
75 | |
46 | |
31 | |
28 |
User | Count |
---|---|
99 | |
93 | |
50 | |
49 | |
46 |