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

[@posagopinath369]

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

[@nivi5476]

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

[@avinashnl9588]

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

[@srikanth7368]

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

[@Alan.DL7]

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. SQLBI video: kzbin.info/www/bejne/mmm1nmqarLJpncU

[@anuninan664]

Not working for me

[@Nextwhatguru]

Thank you Mi Tutorials

[@sarabashi1269]

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

[@thepucpcinogrumpycat6975]

Exactly what I needed. Thank you Sir

[@sarihaddu]

I have data sales data upto March 2023 but the calendar table has dates up to December 2023. When I don't select any month is slicer, the column chart is empty. How to remove months from Slicer which don't have any corresponding sales data? I don't want April 2023-Dec 2023 to show in slicer here.

[@MITutorials]

There are multiple ways of doing this - try to add the sales filter and choose to display non blank sales.

[@sarihaddu]

@@MITutorials Got it. Thank you so much.

[@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

[@nachikettikekar2903]

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

[@ankitprajapati3208]

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

[@shraddhaverma4795]

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

[@sureshrao174]

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

[@iira1311]

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

[@user-fb1zf7kq7m]

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

[@user-je9yp3vp5w]

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

[@MITutorials]

Change the Interval from Month to Year in the Dax.

[@diazjubairy1729]

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

[@MITutorials]

If it's a new measure then yes you need another slicer.

[@janardhanreddy4962]

Nice

[@harichandrareddysagili7700]

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

[@sampathkumarkumar5071]

how to exclude current year in matrix actually same formula i followed but i need not to show current year data

[@Sah-dd1zh]

Yep… doesn’t work for me at all.

[@vibhors50]

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

[@MITutorials]

Please see the dataset below. docs.google.com/spreadsheets/d/1nIBLpCvdVcM2dsec7kGlkjSri92MkImg/edit?usp=share_link&ouid=104221769290538600399&rtpof=true&sd=true

[@ErcoGardiner]

hart line months not sorting correctly , I dont know why

[@SEVideoQuant]

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

[@arokiarajan1230]

Thank you..

[@gaetanomanino1932]

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

[@MITutorials]

Please watch this tutorial. How to Calculate Running Total / Cumulative total over Years and Months in PowerBI | MITutorials kzbin.info/www/bejne/laHNqIeVgJubibc

[@jholwol2699]

somehow even after following all the steps i am unable to get the result

[@ankurarora7632]

when i am clicking on slicer, it shows only that particular month data. its not showing last 6 months

[@sarihaddu]

Post the dax formula here

[@ankurarora7632]

it worked. thanks@@sarihaddu

[@mananshukla5001]

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

[@MITutorials]

How to Create Calendar Table using DAX in PowerBI | MI Tutorials kzbin.info/www/bejne/hZinYYGggMqKerc

[@sakibzamanmohammad8895]

How can we do the same in excel....please help.

[@ankurarora7632]

can you please share the pbix file

[@thompham8903]

thăn kiuuuuuuuuuuuu

[@xcelskills646]

How to get the last 4 weeks data based on slicer selection

[@MITutorials]

In the Interval select Days and enter -30