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.
Hi all,
I am trying to create a matrix that will have some text values in the columns.
Unfortunetaly Power Bi assumes that i want the first value as subtotal or grand total.
I almost got it working by creating a measure:
Text_Measure =
var CurrentItem = SELECTEDVALUE(Projects[KEY])
RETURN
SWITCH(CurrentItem;
CurrentItem;SELECTEDVALUE(Projects[Text]);
blank()
)
The only problem i run into now that it will still shows the first value in the subtotals if there is only ONE value.
See example below:
(First_text) is the "normal" column, Text_Measure is the measure i have created that is stated here above.
As you can see it only shows a subtotal if there is only one value.
Someone has an idea how to remove the subtotal if there is only one value??
Many thanks!
Click the matrix, go to format, then subtotals and turn them off.
i hope i understood what you where looking for
use the hasonefilter function
i do not have your source data to replicate your measure but in the example below
i have a text colunm that will say Project + project number as text but only in the subrows nothing shows in subtotals or grand totals as these are replaced with blank
Measure = Var o = "PROJECT" & MAX('Table'[PROJECT]) var ret = if(HASONEFILTER('Table'[PROJECT]),o,blank()) return ret
var o can be replaced with what ever you want to appear in your table
var ret then checks if the value has only one filter for the project colunm
Proud to be a Super User!
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 | |
94 | |
80 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |