Forum Discussion
How to show trend data based on date
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 ?
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.
9 Replies
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.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)
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.
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.
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.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.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.
