Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
Let me give a brief description of my setup.
I have a FACT table with [contract] and [id] columns.
I have several DIM tables with each an [id] column.
Created a BRIDGE, where I added all the DIM table [id] columns and created a relationship between FACT and DIMs(many) to BRIDGE(one).
My report has several pages, each displaying data from a specific DIM table.
On page 1 I have a slicer, filtering by fact[contract] and fact[id].
On page 2 I want to propagate the slicer selection on page 1, specifically the [id] to display data from corresponding DIM table.
My FACT table has all [id], and each DIM has only it's corresponding [id]s so on page 1 I have to filter by fact[id] and not bridge[id] otherwise not all the [id]s show up in my slicer.
On page 2 I cannot sync my slicer (I've added it to the same slicer group but to no avail).
The two workarounds I've found are:
1) add a table visual, added fact[contract] and bridge[id].
when I click on the [id] all my card visuals display the correct info.
2) created two measures: first -> selectID = selectedvalue(fact[id])
second ->
Solved! Go to Solution.
@td1n1z , Based on what I got so far.
If the measure is calculated in such a manner that if is filtering the data, then that measure needs to be the part of drill through visual to filter it
created an example here - Power BI Drill Through when Userelationship is used in a Measure- https://youtu.be/1BM_WGATrQA
But if you measure is creating a value that can used in slicer, that you need dynamic segmentation
Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k
Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ
Customer Retention with Dynamic Segmentation, New/Lost/Retain Customer Count: https://youtu.be/EyL7KMw877Q
Power BI ABC Analysis using Window function, Dynamic Segmentation: https://youtu.be/A8mQND2xSR4
@td1n1z , Based on what I got so far.
If the measure is calculated in such a manner that if is filtering the data, then that measure needs to be the part of drill through visual to filter it
created an example here - Power BI Drill Through when Userelationship is used in a Measure- https://youtu.be/1BM_WGATrQA
But if you measure is creating a value that can used in slicer, that you need dynamic segmentation
Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k
Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ
Customer Retention with Dynamic Segmentation, New/Lost/Retain Customer Count: https://youtu.be/EyL7KMw877Q
Power BI ABC Analysis using Window function, Dynamic Segmentation: https://youtu.be/A8mQND2xSR4
User | Count |
---|---|
99 | |
86 | |
80 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |