Forum Discussion
Helper VHow to show trend data based on date
manojk_pbi Oh, just go to the Format tab. Select your Date slicer and in the Format tab select Edit interactions. Turn off interactions on your line chart.
Helper VHello Greg_Deckler , Thanks for your reply. I forgot to add sample data in my previous post.
Below is the sample data and expected out put.
Scenario: Report has filter option to select particluar project and reporting date. On selection of the data, report will showcase all necessary kpis for the selected period and the previous one. Along with the kpis i need to display the trend chart of the selected project irrespective of date selection. Please guide me how we can achieve this requirement
| PRJ_MONTHKEY | PRJ Name | Division | BU UNIT | ReportingDate | KPI | Cost |
| PRJ1-Apr-25 | PRJ1 | DIV1 | BU1 | 25-Apr | 60% | 1.6 |
| PRJ2-Apr-25 | PRJ2 | DIV1 | BU1 | 25-Apr | 85% | 8.2 |
| PRJ3-Apr-25 | PRJ3 | DIV1 | BU2 | 25-Apr | 79% | 3.0 |
| PRJ4-Apr-25 | PRJ4 | DIV1 | BU3 | 25-Apr | 93% | 10.2 |
| PRJ5-Apr-25 | PRJ5 | DIV1 | BU1 | 25-Apr | 85% | 4.7 |
| PRJ6-Apr-25 | PRJ6 | DIV2 | BU1 | 25-Apr | 85% | 3.5 |
| PRJ7-Apr-25 | PRJ7 | DIV2 | BU1 | 25-Apr | 60% | 11.0 |
| PRJ8-May-25 | PRJ8 | DIV2 | BU3 | 25-May | 60% | 7.5 |
| PRJ1-May-25 | PRJ1 | DIV1 | BU1 | 25-May | 85% | 0.4 |
| PRJ2-May-25 | PRJ2 | DIV1 | BU1 | 25-May | 60% | 2.5 |
| PRJ3-May-25 | PRJ3 | DIV1 | BU2 | 25-May | 60% | 11.8 |
| PRJ4-May-25 | PRJ4 | DIV1 | BU3 | 25-May | 60% | 6.5 |
| PRJ5-May-25 | PRJ5 | DIV1 | BU1 | 25-May | 60% | 3.5 |
| PRJ6-May-25 | PRJ6 | DIV2 | BU1 | 25-May | 60% | 4.3 |
| PRJ7-May-25 | PRJ7 | DIV2 | BU1 | 25-May | 85% | 9.7 |
| PRJ8-May-25 | PRJ8 | DIV2 | BU3 | 25-May | 43% | 1.9 |
| PRJ1-Jun-25 | PRJ1 | DIV1 | BU1 | 25-Jun | 60% | 10.8 |
| PRJ2-Jun-25 | PRJ2 | DIV1 | BU1 | 25-Jun | 85% | 8.0 |
| PRJ3-Jun-25 | PRJ3 | DIV1 | BU2 | 25-Jun | 79% | 6.6 |
| PRJ4-Jun-25 | PRJ4 | DIV1 | BU3 | 25-Jun | 93% | 5.5 |
| PRJ5-Jun-25 | PRJ5 | DIV1 | BU1 | 25-Jun | 85% | 5.3 |
| PRJ6-Jun-25 | PRJ6 | DIV2 | BU1 | 25-Jun | 85% | 3.4 |
| PRJ7-Jun-25 | PRJ7 | DIV2 | BU1 | 25-Jun | 60% | 6.6 |
| PRJ8-Jun-25 | PRJ8 | DIV2 | BU3 | 25-Jun | 60% | 10.6 |
| PRJ1-Jul-25 | PRJ1 | DIV1 | BU1 | 25-Jul | 85% | 9.5 |
| PRJ2-Jul-25 | PRJ2 | DIV1 | BU1 | 25-Jul | 60% | 1.8 |
| PRJ3-Jul-25 | PRJ3 | DIV1 | BU2 | 25-Jul | 60% | 4.3 |
| PRJ4-Jul-25 | PRJ4 | DIV1 | BU3 | 25-Jul | 60% | 0.4 |
| PRJ5-Jul-25 | PRJ5 | DIV1 | BU1 | 25-Jul | 60% | 2.1 |
| PRJ6-Jul-25 | PRJ6 | DIV2 | BU1 | 25-Jul | 60% | 0.1 |
| PRJ7-Jul-25 | PRJ7 | DIV2 | BU1 | 25-Jul | 85% | 11.2 |
| PRJ8-Jul-25 | PRJ8 | DIV2 | BU3 | 25-Jul | 43% | 3.3 |
The selection is for PRJ1 for current month (Jul25)
Community Championmanojk_pbi Oh, just go to the Format tab. Select your Date slicer and in the Format tab select Edit interactions. Turn off interactions on your line chart.
- manojk_pbi
Hi Greg_Deckler ,
I don't the options for edit interations. Pls could share me the snapshot.
Just to clarify, i have slicer in main selection page and required report in another page. I am using Sync slicers features to reflect the selections.
- Greg_Deckler
manojk_pbi In your case, you would use the slicer on the page that the report is on and edit it's interactions: