Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I've created this matrix showing client name in the rows, total weekly hours billed by relative date filtering (most recent including today) in the last 60 days sorted by the client with the most hours. I would like to add the following:
Thank you.
Hi @ngerasimow ,
1# We can't sort the visual by column directly now, but you can refer to below topic.
https://community.powerbi.com/t5/Desktop/Matrix-Column-Head-Order/td-p/71572.
By adding a custom column in Query Editor you can sort the matrix.
2# Sorry i don't understand, what's the hour variance in your data? Can you explain to me and show some sample data?
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Jay.......my filter type is "Relative date filtering" and looks at the last 60 days. I can't see how I can specify that in the creation of the new index column. It looks like I have type in a specific date but the matrix filter is constantly updating for the last 60 days. Is there anyway to set that up that type of index criteria in the conditional column?
Hi Jay.....I explain item #2 as follows:
Does anyone have a solution to the above issue? Would greatly appreciate any help on this.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |