Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi there,
I'm trying to implement a dashboard with multi-level filtering. In my scenario, different sets of time-series data can trigger events if they surpass certain setpoints and a table of events is produced. An events table might look something like this:
Date ParameterID Event Description
1/5/2018 1 Data 1 Limit Breach
1/6/2018 2 Data 2 Limit Breach
1/6/2018 4 Data 4 Limit Breach
4/7/2018 1 Data 1 Limit Breach
I want users to be able to select an event and get a trend showing details of the event. So if they pick the third event in the above table, a line chart shows minutely data for Data 4 on 1/6/2018.
ParameterID Timestamp Value
4 1/6/2018 09:00:00 5
4 1/6/2018 09:01:00 23
4 1/6/2018 09:02:00 44
etc.
Not shown from minute data table when filtering is working (different dates or different parameterIDs):
1 1/6/2018 09:00:00 77
5 2/6/2018 09:01:00 52
4 6/6/2018 14:02:00 11
Because I'm trying to filter two elements at once (Date and ParameterID), I approached this by adding a column on each of these tables which combine the Date and the ParameterID.
So I end up with:
Date Event DateParameter
1/5/2018 Data 1 Limit Breach 201805011
1/6/2018 Data 2 Limit Breach 201806012
1/6/2018 Data 4 Limit Breach 201806014
4/7/2018 Data 1 Limit Breach 201807041
And a similar column on the timeseries minute data table:
ParameterID Timestamp Value DateParameter
4 1/6/2018 09:00:00 5 201806014
4 1/6/2018 09:01:00 23 201806014
4 1/6/2018 09:02:00 44 201806014
1 1/6/2018 09:00:00 77 201806011
5 2/6/2018 09:01:00 52 201806025
4 6/6/2018 14:02:00 11 201806064
I was then able to make a relationship between the dateparameter columns of each table, and my filtering works when I select whichever event from the table.
Whether this approach was the right one, I'm not yet sure. It seems to work,
BUT
If I click anywhere on my line chart, the filtering seems to reset, for both the table selection and the line chart. This is despite the filtering only flowing in one direction. What's going wrong?
What I am aiming for ultimately is for another line chart to show more zoomed in data (about an hour's worth, centred on the selected data point).
Thanks in advance.
This behaviour isn't happening when I use a proper slicer instead of a table to do my filtering. Is this expected behavior of non-slicer visuals used for filtering? Is there a way I can make a table a slicer, or make my slicer look more like a table?
Hi @veovic,
In your scenario, you create a slicer using [Event] column. And create a relationship between two tables by using the dateparameter. Create a line chart using [ParameterID], [Timestamp], [Value], which will filtered when you click each event in the slicer.
>>Is there a way I can make a table a slicer, or make my slicer look more like a table?
A table visual can not be supported up to date, please review the following idea and vote it.
Table Slicer!
Best Regards,
Angelia
User | Count |
---|---|
106 | |
86 | |
81 | |
74 | |
71 |
User | Count |
---|---|
112 | |
101 | |
96 | |
74 | |
67 |