Forum Discussion

vbvbvb's avatar
vbvbvb
Microsoft Employee
5 years ago
Solved

Blank values for Data slicer using only SPO list as data source

Hi all,   PBI noob here - i have PBI which is using columns from SharePoint Online as data source to produce visuals. It's Data Slicer + Filter using SPO columns and outcome is  heavily dependent ...
Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    5 years ago

    Hi vbvbvb 

    Download sample PBIX with the following visuals and data

    Presumably these cards are displaying things like Count or Sum of some columns?  You could write measures to do the same and specify 0 if the result is Blank e.g.

    Measure = 

VAR _Count = CALCULATE(COUNTROWS('Example Data'), FILTER('Example Data', 'Example Data'[Scenario ] = "No Customer Name"))

RETURN

IF(ISBLANK(_Count), 0, _Count)

     

    Or you can set Conditional Formatting on the cards to make the text white when the value is (Blank).

     

    Regards

    Phil

     

vbvbvb's avatar
vbvbvb
Microsoft Employee
5 years ago

Hi PhilipTreacy ,

 

Thanks for checking, I don't know what core operation is performed here on each data slicer - either it's sum or count etc, because it's not visible and I don't know where to check that. From UI point of view, it looks like - drag and drop Data Slicer, select column you need from imported SPO List Data to act as Filter - that's it.

If I understood your advice correctly, only way to work around that is to 'mimic' same functionality with new measures for each of these data slicers?

vbvbvb's avatar
vbvbvb
Microsoft Employee
5 years ago

PhilipTreacy ,

 

So I tried to use your suggested measure syntax, it works fine - I just had to use more && and || for multi-filters and instead of Data Slicent, to use 'Card' visual - but result with these measures is 1:1  to the Data Slicer. Thanks a lot!