Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register 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/
User | Count |
---|---|
85 | |
79 | |
64 | |
52 | |
46 |
User | Count |
---|---|
101 | |
44 | |
41 | |
39 | |
37 |