User Profile
akos_skutovics
Helper I
Joined 5 years ago
User Widgets
Contributions
Re: DAX Date Range Summary
I understand your point, but I have to disagree with this perspective. If a user wants to gain insights more quickly and efficiently, I don't think it's fair to respond with, "you just need to improve and think faster." Not to mention other scenarios when the insights need to be shared with others, or for pages with several dropdown slicers.Re: DAX Date Range Summary
When 2024 Q1 and September 2023 are selected, I would probably default back to month level: Sep 2023, Jan-Mar 2024. The use case is to display a summary of what is shown on a page in combination with other slicers and description of the main visuals, for easy understandability for people who does not have a lot of experience with consuming Power BI content. What would be the most optimal way to tackle this?DAX Date Range Summary
Does anyone have effective DAX code for summarizing a selected date range in an easily readable format for both continuous and non-continuous periods? I typically use a slicer with these columns: Year (2023, 2024) Quarter (Q1, Q2) Month (Jan, Feb) Or structured like this: Year (2023, 2024) Year-Month (2023-01, 2023-02) Expected output examples: If 2023 Q4, 2024 Q1, and 2024 Q2 are selected, the output should be: 2023 Q4 - 2024 Q2 If 2023 Q4 and 2024 Q2 are selected, the output should be: 2023 Q4, 2024 Q2 If Jan 2024, Feb 2024, Mar 2024, and Apr 2024 are selected, the output should be: Jan - Apr 2024 If Jan 2024, Feb 2024, Apr 2024, May 2024, and Jun 2024 are selected, the output should be: Jan - Feb 2024, Apr - Jun 2024 And so on.hide measure completely from matrix, except in totals while having "switch values to rows" turned on
In matrix visual, I turned on the option "Switch values to rows" This is how it looks now: I want to display "measure2" only in the totals. I know HASONEVALUE could be used to not show values in line for "measure2", but I would like not to show "measure2" at all. Is it possible somehow?Re: sort column with duplicate values by another column
Thank you for your reply Anonymous, 1) Sorting doesn't really work for me, since I would like to present the accounts in various ways where adding a sort measure as you presented is not an option. 2) Could you please explain why your solution is better than just taking the 'sort' column from the first Tablesort column with duplicate values by another column
I want to sort the account column based on the sort column. In the report, users would single-select from the report column {1, 2}. Based on the selection, accounts would be sorted differently. report account sort 1 account1 1 1 account2 2 1 account3 3 2 account1 1 2 account2 3 2 account3 2 Obviously, it is not possible to simply sort account columns based on the sort column, but is there a trick to achieve the end result mentioned above? I would like to use the original account names if possible (no ragged values).
