Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
my manager has a stacked column report which is showing sales since 2012 by year up to 2019, then in 2019 it changes to monthly, and in April 2019 it changes to sales per day. I wanted to create the same in power bi with stacked column chart but not showing month for previous years and days for previous months because I know how to group dates.
Please help!
Thanks
Solved! Go to Solution.
Hi @Anonymous
Business Rule
Solution
This will set the value as 1 for all dates in 2008 and 2,3,4 for all dates in
2007,2006,2005 respectively.
This will set the value as 1 for July 2008 and from 2 onwards for months
Prior to July 2008.
I have attached the pbix for your reference.
Cheers
CheenuSing
Hi @Anonymous ,
Can you share the pbix / data on one drive / google drive and post the link here to formulate a solution.
Cheers
CheenuSing
Hello @CheenuSing
As I mentioned it was a print out of a report in excel not PBI! don't tell me it's a weird request since it's made in excel and being used so many times.I believe there should be an easy way to do it in PBI
Hi @Anonymous
Business Rule
Solution
This will set the value as 1 for all dates in 2008 and 2,3,4 for all dates in
2007,2006,2005 respectively.
This will set the value as 1 for July 2008 and from 2 onwards for months
Prior to July 2008.
I have attached the pbix for your reference.
Cheers
CheenuSing
Hi @Anonymous
Business Rule
Solution
This will set the value as 1 for all dates in 2008 and 2,3,4 for all dates in
2007,2006,2005 respectively.
This will set the value as 1 for July 2008 and from 2 onwards for months
Prior to July 2008.
Cheers
CheenuSing
User | Count |
---|---|
124 | |
106 | |
99 | |
63 | |
59 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |