Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
I'd love some advice please tried looking all over the place but just can't quite seem to find an anwser that fits the issue.
I have KPI page. Which shows last months values and has small line chart under each KPI which shows last 3 months. see below
Now currently we have number of date tables , in these is a field in called "is current month". This has a true or false value depending if its last month or not. This allow us to default to the current month. If you select from line chart then it will filter the report accordingly to one of the other months.
KPI Number of Calls for last month = IF(
ISFILTERED(dim_CALENDAR_CallStartDate[Monthnumber]),
COUNTROWS(fact_Call),
CALCULATE(COUNTROWS(fact_Call),dim_CALENDAR_CallStartDate[Is Current Month] = "True")
)
However this means each measure has to have this code to work. (We have default data set across multiple reports, so dont really want to have to recreate measures for the same thing with just this extra data for one report).
I want away to be able to filter whole page down to either previous month or one selected from line chart. Without use of a slicer, so it's seemless.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
10 | |
10 | |
10 | |
10 |
User | Count |
---|---|
19 | |
14 | |
13 | |
11 | |
8 |