Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
I have a page which requres me to change two date fields to the same date value.
These date fields are in different purposes and impact different visuals on the page.
Is there a single slicer that allows multiple date fields to be impacted based on the date set in the slicer?
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThanks for your help!
There are two tables
One table has typical Defect data
One table has typical Execution data
Defect Data Table Sample
Defect ID | Application | Provder | Project | Release | Priority | Status | System | Summary | Detected On |
726 | App 1 | Comp 1 | Changes Output | February | 3-High | Closed | Output | Bad Output | 1/31/2019 |
888 | App 2 | Comp 2 | Input Changes | May - 19 | 5-Urgent | Closed | Input | Bad Input | 3/12/19 |
Exectution Data Table Sample
Application | Test ID | Exec Date | Test: Execution Status | Name | Project | Release | Status | Subject |
App1 | 856531 | 1/23/2019 | Passed | Test 1 | Project 1 | Jan | Passed | Subject 1 |
App2 | 855625 | 1/10/2019 | Passed | Test 2 | Project 2 | 18L-December+ | Passed | Subject 2 |
App3 | 854618 | 1/18/2019 | Passed | Test 3 | Project 3 | 19B-February | Passed | Subject 3 |
One stacked column chart displays the number of defects written monthly
Second stacked column chart displays the number of test cases executed monthly
I am trying to use one slicer to control both charts.
As the relationship I had setup do not work between these tables as there is no real common thread
If I have 2 slicers one set for Detected on and the other set to use Exec date it works fine but looks really dumb obviously
Thanks for your help....
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |