Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register 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.
User | Count |
---|---|
84 | |
73 | |
70 | |
42 | |
35 |
User | Count |
---|---|
114 | |
56 | |
52 | |
43 | |
42 |