Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
In matrix visual Fiscial year week number currect weeknumber have display first in order.
kindly help me i am getting asc,desc order only like 1-52,52-1 it is displaying
Hi,
when i am using the below code means order is coming like this
but have to display order like this(eg)38,37,36
To display the current week number first in a matrix visual in Power BI, you can use a calculated column to identify the current week and then sort the matrix visual by this column.
Here is an example of how you could create a calculated column to identify the current week:
Click on the "Modelling" tab in the ribbon and select "New Column" from the "Columns" dropdown.
In the "New Column" window, enter a name for the calculated column, such as "Current Week".
In the "Formula" field, enter a DAX expression to identify the current week. For example, you could use the WEEKNUM function to determine the week number for the current date, and then use the IF function to check if the week number is equal to the current week number.
Here is an example of a DAX expression that you could use:
This expression will return a value of 1 for the current week and 0 for all other weeks.
To sort the matrix visual by the calculated column, click on the "Sort By Column" option in the Visualizations pane and select the "Current Week" column as the sort column. Set the sort order to "Descending" to display the current week first.
I hope this helps! Let me know if you have any further questions or if you need further assistance.
User | Count |
---|---|
50 | |
23 | |
18 | |
18 | |
14 |
User | Count |
---|---|
91 | |
85 | |
46 | |
28 | |
21 |