Forum Discussion
field parameter & two stacked column charts
Hello everyone!
I'm stuggling with a field parameter table.
So what i need is to be able to switch between absolute and percentage values and display those in 2 different stacked columns. sample data with all information. -->
https://drive.google.com/file/d/19sDfRxoOWVj_KUhBYjQvg5dOFEh2sfo_/view?usp=sharing
I built a field parameter table for slicing by absolute and % values. Also, what I currently have is
2 measures created_abs , created_perc for the table Created Tasks AND
2 measures resolved_abs, resolved_perc.
What i'm trying to achieve is is one measure for the parameter table "switch" for absolute values in two tables (they represent diffrent kidns of informations). so when i click on absolute: created_abs values are displayed in the Created Tasks table and resolved_abs values are displayed in the Resolved Tasks table. AND SAME applies for % values in 2 tables. (one measure for both %measures)
I tried to play with switch(), but couldn't find a solution.
the "switch_created" slicer uses created_abs and created_perc measures at the moment.
I'd appreciate any help π
Thanks
You will have to create another Calendar table and use the IsInScope function to switch between Created and Resolved tickets - Please see the pbix attached.
Ismail
π₯ Check out my YouTube Channel for Power BI tips & tutorials!
π MiTutorials - Power BI Learning Hub
2 Replies
- miTutorials
Super User
You will have to create another Calendar table and use the IsInScope function to switch between Created and Resolved tickets - Please see the pbix attached.
Ismail
π₯ Check out my YouTube Channel for Power BI tips & tutorials!
π MiTutorials - Power BI Learning Hub- sambgv
Helper I
thanks miTutorials ! this is a very cool solution. However, eventually this report is one of many reports, that will be included in one dashboard. For these dashboard, one common date field will be used to filter by month/year. do you think it will be problematic with the current model in this report?