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 have a client requesting a table that looks like this. The problem is the heirachy they want is based on 3 different fields,
If I put Major project then Job Type then Customer name on the rows of the matrix I can use the + button to hide all the cusotmers in the top part (the are MP=N). I coudl collpase all of the MP=Y section, but then cant see the one row for QEF. Also The MP orange number needs to be all jobs that are MP except the QEF one.
So the question is whether this s possible in power BI? Do I create a column and classify each line to where it fits on the table?
Thanks ofr any advice
Mike
Solved! Go to Solution.
Hi @masplin
You could use "group and bins", it can partly achieve your requirements.
Hi @masplin
Sorry, i'm not clear about your table structure.
Do you have the table as below
Then want the columns to show on rows as the right one.
Hi Maggie
Attached is an example of my data (its actually made up of related tables)
So a normal matrix would look like this
However the customer want the "Y" bit of the table to be split between one speciifc project for cusotmer X and the rest instead of being split by "Group" as for the "N" bit of the table.
One way of doing this is to create a new column in my datatable like this and then use this field instead of the [Major project] field in my matrix.
Daily = IF('ASC'[Order Number]="1431027","QEF",IF('ASC'[Major Project]="Y","Other MP","Net Dom"))
This sort of works, but wondered if there was a more flexible way to show subsets of data. For example if we put "Customer" in the matrix we can either have the total or expand it to show the number for each cusotmer. What if I wanted to show subtotals for all the cusotmers begining with "A" and another total for the rest. I could create a calcuated column as above, but is that the only way or can it be done with DAX?
Thanks
Mike
Hi @masplin
You could use "group and bins", it can partly achieve your requirements.
Ah brilliant just what i needed.
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |