topic Re: How to Display Month and weeks in 100% stacked column Chart in DAX Commands and Tips

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

Anonymous — Tue, 14 Apr 2020 09:51:10 GMT

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

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

RobbeVL — Tue, 14 Apr 2020 09:59:37 GMT

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

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

Anonymous — Thu, 16 Apr 2020 06:14:55 GMT

How write a Dax monthwise as well as weekwise also

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

Anonymous — Thu, 16 Apr 2020 12:40:24 GMT

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

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

Anonymous — Fri, 17 Apr 2020 06:07:40 GMT

(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?