topic Re: 1 chart with different type date (monthly vs daily) in DAX Commands and Tips

1 chart with different type date (monthly vs daily)

Anonymous — Mon, 11 Jul 2022 11:14:30 GMT

hi everyone

hope you are healthy

i've problem to comparing actual monthly vs actual daily in 1 chart.

is it possible to make 1 chart with a combination of monthly and daily?

Re: 1 chart with different type date (monthly vs daily)

Jihwan_Kim — Mon, 11 Jul 2022 11:41:28 GMT

Hi,

I am not sure if I understood your question correctly, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

I hope this can provide some ideas on how to create a solution for your data model.

Qty total expected result: = IF ( SELECTEDVALUE ( 'Axis create'[Required axis] ) = "January", CALCULATE ( SUM ( Data[Quantity] ), TREATAS ( VALUES ( 'Axis create'[Key] ), 'Calendar'[End of Month] ) ), CALCULATE ( SUM ( Data[Quantity] ), TREATAS ( VALUES ( 'Axis create'[Key] ), 'Calendar'[Date] ) ) )

Re: 1 chart with different type date (monthly vs daily)

Anonymous — Mon, 11 Jul 2022 11:59:12 GMT

awesome Kim,

thanks for help me

but if I use this code - SELECTEDVALUE ( 'Axis create'[Required axis] ) = "January" -the report it can be static. what if the month changes (Jan to Feb, Feb to Mar, Mar to Apr etc)? can I use code previous month Kim?

Re: 1 chart with different type date (monthly vs daily)

Jihwan_Kim — Mon, 11 Jul 2022 12:10:11 GMT

Hi,

Thank you for your feedback.

May I ask how the current month is selected on the report page? Is it selected by a slicer selection on the report page? Or, do you want to show all months and dates on one visualization?

Or, please share your sample pbix file's link here, and then I can try to come up with a more accurate solution.

Thanks.

Re: 1 chart with different type date (monthly vs daily)

v-xiaotang — Thu, 14 Jul 2022 10:27:50 GMT

Hi Anonymous

I just want to confirm if you resolved this issue? If yes, you can accept the answer helpful as the solution or share you method and accept it as solution, thanks for your contribution to improve Power BI.

If you need more help, please let me know.

Best Regards,

Community Support Team _Tang

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

Re: 1 chart with different type date (monthly vs daily)

Anonymous — Mon, 18 Jul 2022 04:46:28 GMT

May I ask how the current month is selected on the report page?

only two months, in chart I want to show previous month (month to date) and current month (daily)

Is it selected by a slicer selection on the report page?

yes Kim, for current month I want to choose the date I like

do you want to show all months and dates on one visualization?

only prev month and daily current month

Re: 1 chart with different type date (monthly vs daily)

Jihwan_Kim — Mon, 18 Jul 2022 17:38:38 GMT

Hi,

Please check the attached pbix file.

I created a new Axis table, and applied the below measure.

Qty total expected result: = VAR _currentmonthend = MAX ( 'Calendar'[Date] ) VAR _previousmonthend = EOMONTH ( _currentmonthend, -1 ) RETURN SWITCH ( TRUE (), SELECTEDVALUE ( 'Axis table'[Monthkey] ) = _previousmonthend, CALCULATE ( SUM ( Data[Quantity] ), FILTER ( ALL ( 'Calendar' ), 'Calendar'[End of Month] = _previousmonthend ) ), CALCULATE ( SUM ( Data[Quantity] ), KEEPFILTERS ( FILTER ( ALL ( 'Calendar'[Date] ), 'Calendar'[Date] = MAX ( 'Axis table'[Datekey] ) ) ) ) )