Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
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,
@amitchandak , Thanks ...Unpivot has worked. Here I cannot do bookmark, because I am using 2 different dimensions altogether.
@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/
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
112 | |
90 | |
83 | |
76 | |
64 |
User | Count |
---|---|
146 | |
111 | |
109 | |
103 | |
96 |