topic Re: How to show trend data based on date in Developer

How to show trend data based on date

manojk_pbi — Wed, 13 Aug 2025 17:40:01 GMT

Hello,

I have a single table with all necessary details. I need to have filter for Few dimensions, date. On selection of the month report need to show display cumulative actuals spend selected month and below we have trend chart to show how the actuals spent month on month.

I am not able to get the trend chart when selected. How can we acheive this ?

Re: How to show trend data based on date

Greg_Deckler — Wed, 13 Aug 2025 17:46:14 GMT

manojk_pbi Not certain I entirely understand but perhaps this: https://community.fabric.microsoft.com/t5/Quick-Measures-Gallery/Better-Running-Total/m-p/2755666#M885

Otherwise, Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

Re: How to show trend data based on date

manojk_pbi — Thu, 14 Aug 2025 03:15:54 GMT

Hello 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)

Re: How to show trend data based on date

Greg_Deckler — Thu, 14 Aug 2025 14:25:43 GMT

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.

Re: How to show trend data based on date

v-pnaroju-msft — Thu, 14 Aug 2025 17:52:18 GMT

Thankyou, Greg_Deckler, for your response.

Hi manojk_pbi,

We appreciate your inquiry submitted to the Microsoft Fabric Community Forum.
Based on my understanding of the issue, please find attached a screenshot and a sample PBIX file that may help to resolve the problem:

We hope the information provided is useful. Should you have any further queries, please feel free to contact the Microsoft Fabric Community.

Thank you.

Re: How to show trend data based on date

v-pnaroju-msft — Sun, 17 Aug 2025 16:00:20 GMT

Hi manojk_pbi,

We would like to follow up and see whether the details we shared have resolved your problem.
If you need any more assistance, please feel free to connect with the Microsoft Fabric community.

Thank you.

Re: How to show trend data based on date

v-pnaroju-msft — Wed, 20 Aug 2025 15:52:23 GMT

Hi manojk_pbi,

We are following up to see if what we shared solved your issue. If you need more support, please reach out to the Microsoft Fabric community.

Thank you.

Re: How to show trend data based on date

v-pnaroju-msft — Sat, 23 Aug 2025 18:00:31 GMT

Hi manojk_pbi,

We wanted to see if the information we gave helped fix your problem. If you need more help, please feel free to contact the Microsoft Fabric community.

Thank you.

Re: How to show trend data based on date

manojk_pbi — Mon, 25 Aug 2025 13:48:26 GMT

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.

Re: How to show trend data based on date

Greg_Deckler — Tue, 26 Aug 2025 14:07:05 GMT

manojk_pbi In your case, you would use the slicer on the page that the report is on and edit it's interactions: