Display Last 6 Months based on the Slicer Selection | PowerBI Tutorial for Beginners | MiTutorials

Display Last 6 Months based on the Slicer Selection | PowerBI Tutorial for Beginners | MiTutorials

[avinashnl]

Hello Team,

it's a very good video and appreciate your support on my issue which has a similar requirement i.e. want to display values for the current year upon selection of date.

ex:- if I select today(5/08/2022) in the chart it should display all the values till this 1st of Jan 2022 based on month-wise segregation.
Thanks in advance

[srikanth]

Amazing video. This video has solved my real time issue. Please let me know if your offer any course.

[posagopinath]

Can you solve this query,

Write dax measure for running total which should display only till actuals are available
Ex : there is data with plan vs actual. Plan are there for 30 days and actuals only for 10 days, so in the visual it should display actual vs plan running total only till 10th

Note : Actuals and planned values are in same table

[MrRanggoy]

Hi Question, what if I selected Dec 21 but I want to calculate will be start in Nov, Oct, Sep, Aug, Jul and Jun 21

[sarabashi]

Hi, Can you tell me if I want to do -13
week is itpossible with this way? I can not add Week instead of Month in your formula

[nivi]

this is not working for me. you used total sales .my requirement is percentage value divide count of id from table 1 and count of id from table 2 ..thus is my value its not working. please help me

[harichandrareddysagili]

Can share the powerbi which you worked, I am also trying but unable get the tren for 6months

[이엉덩-iz]

is it possible to do same thing in Excel with Power Pivot?

[ΚόλλιαςΓεώργιος]

Hello. Nice job. How could i do the same but for years. For example if i choose 2023 i want to display 2023 2022 2021 2020 2019

[ankitprajapati]

What if I want to add any dimensional column from Order Table in visual.

[nachikettikekar]

How to show the same in matrix visual? I want to show date and sales in the VALUE of matrix.

[iira]

Thank you for the solution but my Date field hierarchy gets removed which is creating problem for slicer, Any solution on that?

[diazjubairy]

if i we want to make another measure in different visualization, does it mean we need to create another slicer for that new visualization ?

[SEVideoQuant]

Where can we get the pbix file to play with the concept. Thx

[sureshrao]

Thank you but, How to write Dax If I select a month in slicer I need to sales chart month wise from Financial year starting I mean from April. No matter which month I select I need sales data from April of the same fiscal year. Pls guide

[vibhors]

Helpful video. How and where can we download the csv file for orders from ?

[shraddhaverma]

Of there is no sales data and if i want to filter all table how can i do that

[Alan.DL]

Word of advice, do a reference to the guys who came up with this solution. Your video is just an exact copy/paste of what SQLBI did. Nothing wrong with spreading the word and the solution but only if you give a shout out to those who actually did it first.

[gaetanomanino]

Hi how can i make it cummulative? Like the 6 months but with running total

[mananshukla]

Can you link the video on how to create the Calendar Table