User Profile
Pallavi_m
Helper I
Joined 3 years ago
User Widgets
Contributions
- 1.6KViews0likes0Comments
MonthYear slicer to be in sync with Year slicer
Hi all, I have two slicers, 1. Year slicer from Calendar Table 2.MonthYear slicer from Table B Year slicer (Calendar table) Year 2020 2021 2022 2023 2024 2025 MonthYear slicer from Table B MonthYear Jan2020 Feb2020 Mar2020 Apr2020 May 2020 Jun 2020 Jul2020 Aug2020 Sep2020 Oct2020 Nov2020 Dec2020 Jan2021 Feb2021 Dec2025 The Calendar table has no relation with table B. Now when I select Oct 2020, then only 2020 has to be avaialble for selection, rest of the years have to be disabled/disappear. How do I achieve this? Help is appreciated.Solved1.1KViews0likes2CommentsHow to get Actuals vs plan vs forecast
Hi team, I have a table with columns like this: I want to compare actual vs forecast vs plan on a line and stacked column chart, in a way to have columns of actual,forecastand plan separately but not stacked on a column. Year Month Actual sales ForecastSales PlanSales 2022 1 50 0 0 2022 2 60 0 0 2022 3 70 0 0 2022 4 110 0 46 2022 5 140 0 46 2022 6 210 0 46 2022 7 317 0 56 2022 8 945 0 202 2022 9 309 0 246 2022 10 312 0 266 2022 11 313 0 574 2022 12 313 146 792 Help is appreciated. ThanksSolved875Views0likes1CommentCumulative monthly totals
Hi, I have a Date table and fact table related by field called Year I want to achieve a table like this: Year MonthNo sales Monthly Cumulative 2022 01 20 20 2022 02 30 50 2022 03 40 90 2022 04 50 140 I have used this dax to obtain this measure Monthly cumulative: Monthly cumulative= calculate(sum(sales), filter(allselected('Date'), 'Date'[Dates]<=Max('Date'[Dates]))) But the result is 140 140 140 140 I want to this in a bar graph too. How do i do this?Solved1.7KViews0likes3CommentsLine and stacked column chart
Hi, I have a chart like this. Now, I have an year column on x-axis. Year 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 I have already claculated measures like total sales etc., on y-axis. requirement: i want years 2015... 2021 to be grouped under A and coloured in grey and current year(2022 , 2023 ,2024 ) to be grouped under B and coloured in blue. Help is appreciated requirement:Solved987Views0likes3Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.