Forum Discussion
Axis Range change dynamically Based on slicer value
Hi Anonymous ,
Based on my test, I created two Range tables and used Bookmarks to realize your scenario.
Here is my data samples.
Step1: Create two measures for each range:
Range is 10 =
SWITCH (
MAX ( 'Range(10)'[Range] ),
"0-10",
CALCULATE (
COUNTROWS ( 'Age Table' ),
FILTER ( 'Age Table', 'Age Table'[Age] >= 0 && 'Age Table'[Age] <= 10 )
),
"10-20",
CALCULATE (
COUNTROWS ( 'Age Table' ),
FILTER ( 'Age Table', 'Age Table'[Age] > 10 && 'Age Table'[Age] <= 20 )
),
"20-30",
CALCULATE (
COUNTROWS ( 'Age Table' ),
FILTER ( 'Age Table', 'Age Table'[Age] > 20 && 'Age Table'[Age] <= 30 )
),
"30-40",
CALCULATE (
COUNTROWS ( 'Age Table' ),
FILTER ( 'Age Table', 'Age Table'[Age] > 30 && 'Age Table'[Age] <= 40 )
),
"40-50",
CALCULATE (
COUNTROWS ( 'Age Table' ),
FILTER ( 'Age Table', 'Age Table'[Age] > 40 && 'Age Table'[Age] <= 50 )
),
"50-60",
CALCULATE (
COUNTROWS ( 'Age Table' ),
FILTER ( 'Age Table', 'Age Table'[Age] > 50 && 'Age Table'[Age] <= 60 )
),
"60-70",
CALCULATE (
COUNTROWS ( 'Age Table' ),
FILTER ( 'Age Table', 'Age Table'[Age] > 60 && 'Age Table'[Age] <= 70 )
),
"70-80",
CALCULATE (
COUNTROWS ( 'Age Table' ),
FILTER ( 'Age Table', 'Age Table'[Age] > 70 && 'Age Table'[Age] <= 80 )
),
"80-90",
CALCULATE (
COUNTROWS ( 'Age Table' ),
FILTER ( 'Age Table', 'Age Table'[Age] > 80 && 'Age Table'[Age] <= 90 )
),
"90-100",
CALCULATE (
COUNTROWS ( 'Age Table' ),
FILTER ( 'Age Table', 'Age Table'[Age] > 90 && 'Age Table'[Age] <= 100 )
)
)
Range is 30 =
SWITCH (
MAX ( 'Range(30)'[Range] ),
"0-30",
CALCULATE (
COUNTROWS ( 'Age Table' ),
FILTER ( 'Age Table', 'Age Table'[Age] >= 0 && 'Age Table'[Age] <= 30 )
),
"30-60",
CALCULATE (
COUNTROWS ( 'Age Table' ),
FILTER ( 'Age Table', 'Age Table'[Age] > 30 && 'Age Table'[Age] <= 60 )
),
"60-90",
CALCULATE (
COUNTROWS ( 'Age Table' ),
FILTER ( 'Age Table', 'Age Table'[Age] > 60 && 'Age Table'[Age] <= 90 )
),
"90-100",
CALCULATE (
COUNTROWS ( 'Age Table' ),
FILTER ( 'Age Table', 'Age Table'[Age] > 90 && 'Age Table'[Age] <= 100 )
)
)
Step2: Create visuals on two pages and use each page as bookmark like this:
The final output is shown below:
Refer to:
Create report bookmarks in Power BI to share insights and build stories - Power BI | Microsoft Docs
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Anonymous5 years agoNot applicable
Hi Anonymous
Thanks for your response,this one make my work very easily.
One more question is there any way to use this one on same page without using bookmark,
beacause my requirement is x-axis value change dynamicaly based slicer value on same graph.I am new to power bi can you please help to get this one.
Thanks in advance