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 on multiple filters used, so question is - is it possible to show these blanks as 0's?
I have seen many posts about using Measures or DAX but all solutions are aiming at different type of data - i can't see what is main difference when SPO is used as data source ? There are no Measures, no forumlas etc, there's just data from SPO in form of table and columbs and then Data Slicer with applied filters - and if combination of these filters return no results, it shows (Blank)'s.
Should Measure with If ... IsBlank to be addeed to Filter as data field? Or there's another way to make sure that every time combination fo filters would produce (Blank) it would turn into 0's instead?