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.
We do not want to show the value in Grand total row for Target, as mentioned in the pic.
Solved! Go to Solution.
HI, @AnujMishra_09
Yes, if you select a value in slicer, ISFILTERED and HASONEVALUE() will return true() and show the value.again in total row.
So you could continue to add a step like this:
for the slicer in this matrix visual, add a new field for it and use it as a slicer
or use the new field as matrix Rows Value.
For example:
add a new AREA column
New AREA = Areas[AREA]Then drag it into slicer and select value from it.
Best Regards,
Lin
Please help why the report is showing wrong total for a simple report.
hi, @AnujMishra_09
After my research, it could achieve by custom format Settings for one measure of the measures.
But you may try this way:
Use ISFILTERED or HASONEVALUE() to create a new measure for this measure
for example:
Measure = IF(ISFILTERED(Areas[AREA]),[Distribution]) Measure 3 = IF(HASONEVALUE(Areas[AREA]),[Distribution])
Result:
Best Regards,
Lin
Sorry Lin, I am facing an issue that when I select a value in Slicer it starts showing the value.again in total row.
Measure = IF(ISFILTERED('Book by week by line'[Site]),[Target])
HI, @AnujMishra_09
Yes, if you select a value in slicer, ISFILTERED and HASONEVALUE() will return true() and show the value.again in total row.
So you could continue to add a step like this:
for the slicer in this matrix visual, add a new field for it and use it as a slicer
or use the new field as matrix Rows Value.
For example:
add a new AREA column
New AREA = Areas[AREA]Then drag it into slicer and select value from it.
Best Regards,
Lin
Even if it does not work then use the visual level filters instead of page level or report level filters.
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 |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |