FIlter multiple fields

Question

Hopefully, I will explain this right.&nbsp;I have 3 columns in one tableAccount Name, Date, ValueI need to display All Accounts (no filter), All values for a given month (filter Month and Year )&nbsp;So I if I were to filter on March 2020 say..Account&nbsp; &nbsp; &nbsp; &nbsp; MTD Value&nbsp; &nbsp; &nbsp; &nbsp; Date[Month],Date[Year]&nbsp; &nbsp; &nbsp; &nbsp;(dates do not appear on the report)Payroll&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2500000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 03&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2020Printing&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 03&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2020Legal&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0/blank&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;--&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; --&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; (no legal for March)Misc Fees&nbsp; &nbsp; &nbsp; &nbsp;50000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;03&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2020&nbsp;I need legal (or any account that has zero transactions for the month ) to still appear, as there is YTD column that will include transactions for other months in another visual beside this one and they all need to line up.&nbsp;I can't use a slicer because I end up with accounts that have no values for those dates disappear from the visualization chart)&nbsp;Thanks again.&nbsp;

parry2k · Answer

TallKewlOnez&nbsp;select&nbsp;show items with no data&nbsp;

I would ❤&nbsp;Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation! 
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡

tallkewlonez · Answer

I have the 'Show Items With No Data' option selected for the account name. However because there are two columns that are summarized (Sum) value, and a % of total column), that option is not visible for those columns. If I uncheck summarize, I get the 'Show Items With No Data' option. However, I still don't get those items once I filter for month and year.

Thanks

v-deddai1-msft · Answer

Hi&nbsp;TallKewlOnez&nbsp;,&nbsp;Would you please try to use measure instead of summarizing on the column in table visual.&nbsp;Best Regards,Dedmon Dai

tallkewlonez · Answer

Thanks for that, it helped, pointed me in the right direction. I also tool some fields out of my fact table., moved them into a dimension table and was able to better work with them (account names) by including the above hint.

Forum Discussion

FIlter multiple fields

4 Replies

Related content

Multiple Date Fields

Measure with multiple filters on same field

Slicer pointing towards multiple fields

Multiple Years Filter

Filtering multiple Fields over multiple Tables