Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

NEW PARAMETER PHASING

Hello, 

 

I want to create a New Parameter that allows me to see what's the phasing according to the day of sales. 

 

For example, we have 20 days of sales in a period so in 19 day we are supposed to be in 95% of sales of the target. 

WORKING DAYS DAYS OF SALES TARGET
2020=Days of sales / Working Days

 

 

By creating this, I'd like to move freely this bar so it indicates me I sould be in 55% of the target as we are in 11 day.

phasing.PNG

Thanks

@NewParameter @Phasing

1 ACCEPTED SOLUTION
v-gizhi-msft
Community Support
Community Support

Hi,

 

You can try to create this slicer table first:

SlicerTable = DISTINCT(SELECTCOLUMNS('Table',"Parameter",'Table'[Day of sales]))

Then try this measure:

Measure =
IF (
    MAX ( 'Table'[Day of sales] ) = SELECTEDVALUE ( SlicerTable[Parameter] ),
    SELECTEDVALUE ( SlicerTable[Parameter] ) / MAX ( 'Table'[Working days] ),
    BLANK ()
)

When select one value in slicer, the result shows:

5.PNG

Hope this helps.

 

Best Regards,

Giotto

View solution in original post

2 REPLIES 2
v-gizhi-msft
Community Support
Community Support

Hi,

 

You can try to create this slicer table first:

SlicerTable = DISTINCT(SELECTCOLUMNS('Table',"Parameter",'Table'[Day of sales]))

Then try this measure:

Measure =
IF (
    MAX ( 'Table'[Day of sales] ) = SELECTEDVALUE ( SlicerTable[Parameter] ),
    SELECTEDVALUE ( SlicerTable[Parameter] ) / MAX ( 'Table'[Working days] ),
    BLANK ()
)

When select one value in slicer, the result shows:

5.PNG

Hope this helps.

 

Best Regards,

Giotto

Greg_Deckler
Super User
Super User

OK, so create the What If parameter, let's call it Phasing perhaps and then you could do this:

 

Measure = SELECTEDVALUE('Phasing'[Value]) / MAX('Table'[Working Days])

 

?

 

If that isn't it, Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.