I am new in using Power BI, but for me it is a little bit strange that it is so "complicated" to display values for the current month. Call me stupid, but in my opinion this should be possible just with one click in the chart properties or somehting like that.
For me the solution with the extra column and 0 or 1 values fitted the best, but I have an additional question which refers to the problem above. Is it possible to display a Text with the current month in the Dashboard like a headline?
Hi @Christian I have the same issue.
To get around this I created a column called Month-Year and then put it on the report as a Multi-Row-Card visual.
When the filters applied to the page change the value in that column will change. The top Jan-2016 is driven by what is selected in the filters. e.g.
This works as filters are applied.
Other option could be if you applied the isinlastmonth = 1 as a filter on the entire page. This will remove the need for those two manual filters to constantly be changed and should just always show the previous month.
Great post by @elliotdixon! So you've got a bunch of filters to determine whether something falls within last 7 days, or last 30 days, or this year. This is fine if we want to apply just one of the filters to the dashboard. But what if we want the user to select which filter to show? For example, say we have these three filters:
Can we show a single filter in the dashboard so that the user can select which one of those three filters (current week, last week, or last 30 days)?
In Tableau, these 'previous week', 'previous month', 'previous 6 month' (etc.) type selectors are already built in.
Thank you for your great suggestions. I've also found value in them!
Is there any possibility to create a measure which displays sum of sales for current week and month?
I'm trying to do this because in the same screen i need to display both values in the same screen and using a slicer does not work for me because it will filter all my data.
I've been searching the web for the past days to come up with a formula but no succes.
It would be of great help to me if i could find a solution to this.
Hi, if you wish, you will be able to learn more here:
@elliotdixonCould you help out with few calculated columns for the datedimm table, please.
I would need some helpo with following dimensions:
Last Week to Date (i.e. is date between week 1 and last week)
Last Week previous year to date
Current Quarter (I have addeda new column QtrofYear dispalying quarter number.)
Current quarter previous year
Quarter X previous year