Dynamic X-Axis Chart based on Parameter

Anonymous — Sat, 08 May 2021 12:22:29 GMT

I am from tableau world and need to know more about PowerBI. I am trying to reflect my tableau dashboard in Power BI.

I have a parameter with values 'YTD','MTD','Previous YTD','Previous MTD','Previous Month','Previous Year','Year-over-year'. In tableau the date values changes in x-axis based on parameter input. Yaxis would display sales and profit.

I tried using below DAX as mesure as well as column. Both resulter in the displayed warning and it didn't work.

Still lot more else statments to be written for YTD, PYTD,etc. But here itself I am facing issue. Also I am not sure why I need to use MAX(Paramter Value). If I use Query2[Analysis Selection], then I get an error in DAX "Cannot find name [Analysis Selection]'.

If I create a seperate tableau I had to inter relate the tables. Is this the way power BI works?

Similarly is there a way to pull a "Any" type Date paramter into slicer/visual and make the dax calculation and visuals react based on single date provided as input instead of choosing edit queries -> edit paramter?

Re: Dynamic X-Axis Chart based on Parameter

daxer-almighty — Sat, 08 May 2021 16:13:09 GMT

You can't use DATESBETEEN as a value for a measure (or a calculated column) since measures return only SCALARS, not tables. Only in one case are you authorized to assign a table to a measure value - when the table holds only one column and one row. In this case DAX turns the table into a value automatically. Also, I'd kindly suggest that you learn about time-intelligence in Power BI because I can see you're doing it incorrectly, which means sooner or later you'll have mistakes/bugs in your figures.

You can start here: https://www.sqlbi.com/articles/time-intelligence-in-power-bi-desktop/

and then head over to: https://docs.microsoft.com/en-us/power-bi/guidance/star-schema

Please learn the philosophy of Power BI and how DAX works to avoid common mistakes.

topic Re: Dynamic X-Axis Chart based on Parameter in DAX Commands and Tips

Dynamic X-Axis Chart based on Parameter

Re: Dynamic X-Axis Chart based on Parameter