Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
I Dont want to show data that dosent have any values.. when selected any of the above element from any matrix.
Eg. i have selected ws non feeder from channel and i only want data that is of ws non feeder and not the blank data.
"the mapping is correctly done".
@Ahmedx
Solved! Go to Solution.
@Anonymous
Hi, two options: 1) you will correct the measure %Total Sales, which gives a value to every line, which is the reason all lines are displayed or 2) you use a filter on every visual (in the left panel) and set that for a certain column, e.g. sales the value must not be blank, or greater than zero.
If I understood you correctly, then you need to rewrite all the measures for example
if you have such a measure :m1 = SUM('table'[Value])
then you should rewrite it like this
m1 =
VAR _t1= SUM('table'[Value])
RETURN
IF(_t1,_t1)
this applies to all measures that are in the matrix
If I understood you correctly, then you need to rewrite all the measures for example
if you have such a measure :m1 = SUM('table'[Value])
then you should rewrite it like this
m1 =
VAR _t1= SUM('table'[Value])
RETURN
IF(_t1,_t1)
this applies to all measures that are in the matrix
@Anonymous
Hi, two options: 1) you will correct the measure %Total Sales, which gives a value to every line, which is the reason all lines are displayed or 2) you use a filter on every visual (in the left panel) and set that for a certain column, e.g. sales the value must not be blank, or greater than zero.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.