Forum Discussion
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 (fact_table) which contains information of both dimension in it.
Output: If I slice metric name appropriate chart should plot yearly for some metrics, and plot monthly for some metrics, and etc.
Let me know can I achieve this,
Thanks
3 Replies
- amitchandak
Super User
Anonymous , there few ways to change axis. Bookmarks, Unpivot the data. In Direct query - Dynamic M parameters
Dynamically change chart axis in Power BI
bookmark -https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
https://www.youtube.com/watch?v=6jeSIRpjv0M
https://datamonkeysite.com/2020/10/22/change-dimension-dynamically-using-parameter-in-powerbi/ amitchandak , Thanks ...Unpivot has worked. Here I cannot do bookmark, because I am using 2 different dimensions altogether.
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.
