Forum Discussion

KolliNaga's avatar
KolliNaga
Regular Visitor
4 years ago
Solved

one week sales

Hi,  Could you please let me know how to show only one week dates in x axis bar chart.    
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    4 years ago

    Hi KolliNaga ,


    Create a disconnected calendar table as a slicer, and then create a measure to apply to the visual level filter:

    Measure = 
var select_week = YEAR(SELECTEDVALUE('Date'[Date]))*100+WEEKNUM(SELECTEDVALUE('Date'[Date]))
var finacials_week = YEAR(SELECTEDVALUE(financials[Date]))*100+WEEKNUM(SELECTEDVALUE(financials[Date]))
return IF(finacials_week=select_week,1,0)

     


    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

ALLUREAN's avatar
ALLUREAN
Icon for Solution Sage rankSolution Sage
4 years ago

Hi, KolliNaga 

If you have a calendar table (date formatted column) you can add new column for week number (1-53)  e.g. WEEKNUM ('CalendarTable' [Date]) and you can use it in a slicer and on X-axis. The same can be done in Power Query, selecting Date column and in Add Column ribbon, Date -> Week -> Weeknum.

 

Check this example:

https://www.dropbox.com/s/iupj4likqc7lol6/week%20on%20x%28allure-analytics.com%29.pbix?dl=0

 

Did I answer your question? Please Like and Mark my post as a solution if it solves your issue. Thanks.

Appreciate your Kudos !!!

https://allure-analytics.com/

https://www.youtube.com/channel/UCndD_QZVNB_JWYLEmP6KrpA

https://www.linkedin.com/company/77757292/

 

 

KolliNaga's avatar
KolliNaga
Regular Visitor
4 years ago

Thakns for response, actuallt i want out put like as menstioned below screenshot, if i select any one date X-Aixs it should show that all 7 days of that week

 

 

 

  • V-lianl-msft's avatar
    V-lianl-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi KolliNaga ,


    Create a disconnected calendar table as a slicer, and then create a measure to apply to the visual level filter:

    Measure = 
var select_week = YEAR(SELECTEDVALUE('Date'[Date]))*100+WEEKNUM(SELECTEDVALUE('Date'[Date]))
var finacials_week = YEAR(SELECTEDVALUE(financials[Date]))*100+WEEKNUM(SELECTEDVALUE(financials[Date]))
return IF(finacials_week=select_week,1,0)

     


    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.