Forum Discussion
Remove Filter context for Dimension
HI Team,
Have 2 Tables one is Transaction table and Other is Date table have mapped these tables using Transcation date in data modelling
In the Below screenshot have a process names and have a data slicer selected from Oct 2021 to 31st March 2022 Since i joined date table with transaction table it is showing all process which are having transactions between selected date range
but i need to all process names even though we dont have transaction tried with "Show items with no data" but not working
any idea? also tried by removing filter context by using ALL(Date) but since process name is dimension need to use aggregation fucntion which will not work in my case
any help would be highly appreciated
2 Replies
Not clear what is your goal here...
a) If you want all list of "Dashboard Process N", create a table with all values of your transaction table. (like dimension). Use this column for your reporting needs and also select show items with no data
b) Other option, if you need only for one page / one or two visualization to exclude the date slicer, you can consider unsync slicer
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers
Click on the slicer
> under the tab Format
> select Edit Interactions
> Turn off the interaction on the visual you don't want the slicer to affect.
Hope this is what is needed for your end output ...
Hi Varun511 ,
but i need to all process names even though we dont have transaction
Sorry for that the information you have provided is not making the problem clear to me. Can you please share more details(like tables , expected outputs) to help us clarify your scenario?Or share me with your pbix file after removing sensitive data.
How to provide sample data in the Power BI Forum - Microsoft Power BI Community
How to Get Your Question Answered Quickly - Microsoft Power BI Community
Best Regards,
Eyelyn Qin
