How to Display Month and weeks in 100% stacked column Chart

[Anonymous]

 

Hi Friends,

We have a data as Year and month and weeks and sales data in power BI.

my output is As per below Image.for example--march-20 you have selected in slicer and in that visuals it should show month March20 data & week data for w1,w2,w3,w4 of March-20.

How to Write Dax In power Bi?

Note- we are using always  live Connection.

Thanks

Godasu

[RobbeVL]

Hi,

What are you live connecting to?
To do someting like this, you will need something to slice on, that means creating a "custom" calculated column or table, as showing 1 day + aggregated data is not standard for time series in PBI.

Regards,
Robbe

[Anonymous]

How write a Dax  monthwise as well as weekwise also

[Anonymous]

If Live Connection means that you cannot create new tables and join them to other tables that exist in the source... then I don't think you can achieve this setup.

It's easy to show weeks or months on a chart but mixing weeks and months requires a quite ingenious technique to structure your time dimension. If you don't have access to the dimension and can't manipulate it, I think you're a bit out of luck.

But ask the same question on other forums, maybe on the Desktop one.

Best
D

[Anonymous]

(if you Have select 1/feb/2020 to 30/March/2020 It Will display selectd months(Feb and March and April) And current month(April) of week1 week2 week3 week4 week5)

i want to display Two visuals to single visual?