matrix

3 Topics

Highlight weekend rows in matrix
I have a requirement to highlight weekend (WEEKDAY 1 and 7) rows as shown in this graphic. I do have a condition set on the value and if there are any values entered into a weekend, the cell does highlight yellow. However, with or without any value, I would like to have the row highlight yellow (or a light yellow). Thanks for the information
Solved
guyatisk
4 years ago Place Desktop
1.2KViews
0likes
2Comments
Matrix Table - keeps on repeating
Hi! Would appreciate insights on where my model is going wrong. I have these tables: (1) Base headcount of employees w/c I am planning to use as dimension (2) Data that would be used for the measures - this table has a person identifier that could be linked to table 1 (3) Dimension table for Region, Business Unit and Country Basically, the stakeholder would want a visual and table that shows how many employees meets the metrics and how many are not. So the table 1 have a mapping of region and business unit per employee w/c was then connected to table 3. Now, the issue is the matrix table. Since they would want as well the list of workers that does not have data in table 2, I have added +0 at the latter part of the DAX that simply count the rows, sum some data, etc. What happens is that, if I visualize it as a table: Region - Business Unit - Worker, the worker appears to ALL regions and BUs w/c should not be the case. Any insights on where did I went wrong? Any help would be appreciated 🙂
Solved
sydney20
4 years ago Place Desktop
1.1KViews
0likes
3Comments
Difference in Matrix instead of Total
I have problem, but I can't solve it. I made matrix from table with values for places each year. I get Total in column to right but I need difference between column nr. 2 and 10 and ratio in next column. I don't find solution for that. My example in Matrix table Place 2011 2012...........2019 Total(but I need difference) East coast 10.605 11.254 21.859 (649) How do I solve this? Best regards, Jóhannes Finnur
Solved
Anonymous
6 years ago Place Desktop
3.6KViews
0likes
6Comments