Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello Everyone
I am working on one task and there is one requirment.
I have Two table in Report View.
I have Two date columns i.e., ACQ Ratification Date and Pass DD Date in both Table Visual and I have two slicer i.e., From Date and To Date in Report View.
From Date slicer has ACQ Ratification Date Column and To Date slicer has Pass DD Date column
I want to combine this two slicer(From Date,To Date) into single one(Date Range) like below Picture.
Output:- After combining two slicer into single one
As shown in above picture.
First date value(11-01-2023) in Slicer should filter Ratified Properties Table Visual and should filter the Table by Acq Ratification Date.
Second date value(17-02-2023) in Slicer should filter Passed DD Properties Table Visual and should filter the Table by Pass DD Date.
Solved! Go to Solution.
If your slicer columns come from the same table then their filter choices will be multiplied (they will influence each other).
To avoid that you could create a copy of your table and then have your two table visuals be influenced by one or the other source table.
@lbendlin Thank You Sir for your hands on knowledge and it helped me to solve my problem.
@lbendlin Sir I have tried some different methods like combine/merging two column(ACQ ratification date and Pass DD Date) into new table but that is also not working as expected.
The Data model looks like below picture.
Required Output ir Expected Output:-
I want to filter two different table Visual i.e., Ratified Properties Table and Pass DD Properties Table from one slicer.
I am not able to create single Date slicer of Style Between with two different column.
The single Slicer should work with two column (ACQ ratification date and Pass DD date).
the value in first field of Slicer should be column ACQ ratification date which should filter Table Visual Ratified Properties and second field of slicer should be column Pass DD which should filter Tabel Visual Pass DD Properties.
Thank You in Advance for helping Sir.
ok, what have you tried and where are you stuck? What does your data model look like?
Hello @lbendlin Sir,
I am Stuck at creating one date slicer with two different column.
Can you help me Sir?
What does your data model look like?
If your slicer columns come from the same table then their filter choices will be multiplied (they will influence each other).
To avoid that you could create a copy of your table and then have your two table visuals be influenced by one or the other source table.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |