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.
Hello All,
I am trying to build a report on perticualr data which is having mutliple project id's.
I have used Chicklet slicer for selection of projects and according to that i tried to build a report.
I would like to know that, can we show blank visuals if no project id is choosed rather than showing all cumulative values of all the projects when no project id is choosed(by default feature).
I have tried below dax measure
Slicerselection = if(calculate(distinctcount('tablename'[PROJECTID]),allselected('tablename'[PROJECTID]))=1,"Y","N")
and i put this measure in every visuals, Visual Level Filter and mentioned Show items when the value is: Contains Y.
Its working fine but for only when i choose single project id.
If i choose multiple project id then it's not working, shows blank visuals.
Please suggest me.
Mohan V
You can use blank() function
CALCULATE (
IF (
CALCULATE ( tablename[projectid] ) = BLANK (),
0,
CALCULATE ( tablename[projectid])
)
Thanks,
Himanshu
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 |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |