Forum Discussion
Specifically packed slicer time-frames
Hello,
We produce monthly SQL Query reports showing revenues per customer for chosen timeframes, so columns are basically packed and rolling, where we usually choose 4 to 7 of these time-filtered revenue columns. Sometimes we'll keep H1 split as quarters and so on.
| Revenue Last Year | Revenue H1 | Revenue July | Revenue August | |
| Customer x | ||||
| Customer y |
Pulling docdate from SAP doesn't work so well and so I've got a time table put in but it's drill down doesnt give the end-visual I'd like to see.
I'm wondering how sensible it is to try produce a slicer with all the 7 possibilities below? I have just started with Power BI and work with a SQL developer, but foresee a lot of DAX statements to try get all these timeframes in a slicer, which then show the columns we want to see at each particular point in the year.
Does anybody have advice or guidance?
| Slicer choices | Order of appearance |
| MTD | 9 |
| LM | 8 |
| MBL | 7 |
| Month before that | 6 |
| LQ | 5 |
| QBL | 4 |
| Quarter before that | 3 |
| LH | 2 |
| LY | 1 |
2 Replies
SAP_B1_Reporter calculation groups are your friend here. Each choice will be a calculation group item and under each item, you will put your logic to return the value. There is a lot of resources on this topic, just do a google search.
✨ Follow us on LinkedIn
Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
sorry for not very sure about your expected result, could you add your expected result in detail, you can take a look at this article, https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523#M607150
-
based on my understanding, you can get the selected value of your slicer, then you can write measures to calculate revenues per customer for chosen timeframes.
because not having your sample data, I can not give you a complicate example. if you need more information, you can share your sample data or file after removing sensitive information, & your expected result.
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
