cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
jlj Frequent Visitor
Frequent Visitor

Is there a way to work out what drilldown level the user is on?

Hi,

New to power bi with bit a of MDX/SSAS knowledge.

I am trying to create a parallelperiod measure for an amount based on the users time period selection. ie

if user is viewing months, I would show previous month, quarter - previous quarter , year - previous year drilling up and down.

In mdx I could work out the dimensions hieararchy level and pass the correct interval, however this does not appear to be possible.

How can I tell where the user is on the date drilldown?

How can I use this to call parallelperiod with the right parameter?

Thanks in advance for your help.

Regards

J

3 REPLIES 3
Microsoft v-huizhn-msft
Microsoft

Re: Is there a way to work out what drilldown level the user is on?

Hi @jlj,

I am still confusing your requirement, could you please share more details and create a sample for analysis?

In Power BI, you can create a hierarchy by right clicking the field->New hierarchy. Then display it in a visual, so that you can drill down and see the specific value. There are some articles for your referance.

Visual hierarchies and drill-down behavior
Understanding Functions for Parent-Child Hierarchies in DAX

Best Regards,
Angelia

jlj Frequent Visitor
Frequent Visitor

Re: Is there a way to work out what drilldown level the user is on?

I want to show the previousperiod based on what level the user is on.

How can if the user is on month, quarter or year level so that the measure has the right parameter.

Unless this cannot be done on fly, ie parallelperiod is hardcoded to year, it will have to show regardless of level user is on.

Does that make sense?

 

Regards

 

Microsoft v-huizhn-msft
Microsoft

Re: Is there a way to work out what drilldown level the user is on?

Hi @jlj,

We can display the value in current level, we are unable to show the previous level value when we click the current level.

Best Regards,
Angelia

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)