Show items that has value only in slicer and sync with all pages

[PBI_newuser]

Hi,

I have 3 Fact tables and 1 Dimension table and I want to sync the slicer with all pages and only show the items when it has value.

How to show only items that has value in slicer for 3 fact tables and also sync the slicer with all pages?

Dim Table

Model

A-123

B-321

C-321

D-321

Fact Table 1

Case Number	Model
AAA	A-123
BBB	B-321

Fact Table 2

Order Number	Model
PO-123	C-321
PO-321	A-123

Fact Table 3

Sales Number	Model
SO-135	D-321
SO-432	B-123

[harshnathani]

HI @PBI_newuser ,

For syncing slicers refers,

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers

https://www.youtube.com/watch?v=qPDjCuvKWCw

https://www.youtube.com/watch?v=BTjsPRPfBsA&vl=en

Regards,

Harsh Nathani

[amitchandak]

@PBI_newuser , You have filter values from all three table <> blank at viusal level.

Same as this video but for 1 slicer

https://www.youtube.com/watch?v=cyOquvfhzNM

also refer -sync slicer in

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers#sync-and-use-slicer...

[PBI_newuser]

Hi @amitchandak,

As I wish to  show items that has value only in slicer, I created the measure for 3 Fact tables and add them at the filter visual level.

Fact Table 1: Count (Case Number) >0

Fact Table 2: Count (Order Number) >0
Fact Table 3: Count (Sales Number) >0

But when I sync with other pages, the filter measures in Fact Table 2 and 3 changed to the filter measure in Fact Table 1.

How can I solve this?

[v-lionel-msft · Accepted solution]

Hi @PBI_newuser ,

"But when I sync with other pages, the filter measures in Fact Table 2 and 3 changed to the filter measure in Fact Table 1."

Indeed, I reproduced your problem. 

So if you do this, you can't sync the slicers. The slicers on different pages will have the same values after being synchronized.

Page1

Page2

Or Maybe you can refer to my .pbix file?

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.