Ok, I'll monitor this thread so if you figure something out please post as the only way I have done this is a bunch of charts and bookmarks. Honestly even making 20 copies of a chart and buttons to select which one is pretty quick and easy though not elegent it works and is the only way I have yet figured out. Could do the bookmarks to switch the X axis and then use multiple tabs to handl the by Area, Product etc...
thanks for the input though I appreciate it. I would normally agree with you but this will become a maintnance nightmare when they are going to make adjustments to these so then I would need to do that X 20 make sense?
so, almost there I have everything working except quarters. Does anyone know the proper way to use the M(Power Query Lanagugage) to do something like this equivilant in excel/PBI Measures ?
|DateFormat = year('Quarter Dates'[DateValue])&"-Q"&ROUNDUP(MONTH('Quarter Dates'[DateValue])/3,0)|
Dateformat =year('Quarter Dates'[DateValue])&"-"&MONTH('month Dates'[DateValue])
I have not been able to find this out yet.
ok-- I figured it out, in case others need this!!
= Table.AddColumn(#"Renamed Columns", "Custom.1", each Text.From(Date.Year([Measure]))&"-"&Text.From(Date.Month([Measure])))
I will keep you updated on final solution.
That woudl be AWSOME!! there are several fairly robust sample data models out there - https://docs.microsoft.com/en-us/power-bi/sample-datasets
Can do dynamic tiles and text boxes but I know of no way to use DAX in a lablel name or any other way to make it dynamic. I'm sure there is an idea out there.. IF not there should be - if you create one let me know and I'll vote for it!