Forum Discussion
Slicer Hide values w/ No Data
Hi,
I have the same problem, I have my customer table related to my Sales table, EBITDA Table and Overdue Table, when I look for a specific segment (which it's in my Customer table), the slicer show me all the customer in the segment with and without sales or overdue.
How I tried to solve this:
In my model i have tables reference to the sales, and overdue table, group by Customer ID, then I union both tables and remove duplicates. with this I have the Customer id with sales, I meger this table to my main customer table, and filter to show only values with no null values.
Hope this result for you.
this can applied in others cases.
Super UserHi,
Share some data. Show your measure here. Also, show your expected result.
As you can see the slicer is showing account no. with no sales. My question is how do I hide the slicers with no sales data.
Seems like there should be an easy solution to this...Can anyone help?
Hi,
I have the same problem, I have my customer table related to my Sales table, EBITDA Table and Overdue Table, when I look for a specific segment (which it's in my Customer table), the slicer show me all the customer in the segment with and without sales or overdue.
How I tried to solve this:
In my model i have tables reference to the sales, and overdue table, group by Customer ID, then I union both tables and remove duplicates. with this I have the Customer id with sales, I meger this table to my main customer table, and filter to show only values with no null values.
Hope this result for you.
this can applied in others cases.