Forum Discussion
Anonymous
5 years agoNot applicable
Dynamically change of x-axis using another column
Hello Everyone, I have following metrics, Please note that I have metric dimensions which needs to plotted as monthly, yearly, quarterly. I also have date dimension. ISMS (...
Anonymous
5 years agoNot applicable
Another query is that, Let me know how to put default period as Monthly.
Please note that my unpivoted columns has Metric name(Col1), Freq(col2), Period(col3).
col2 has monthly, quarterly, annual
col3 has names of month like Jan, Feb, Q1, 2021 etc.
Output: If the filter is not selected it needs to show monthly (by default).
From here I tried to use following DAX,
IF(ISFILTERED('Dummy'[Metric name]),Dummy[Period],FILTER(Dummy,Dummy[Freq]="Monthly"))
It is not working.
Please note that If I filter metric name appropriately axis (either monthly, annual, quarterly) is printing. But by default I want to show default columns as monthly instead of showing all period as mentioned below.
Thanks a lot.