Forum Discussion
Microsoft EmployeeCalculate percentages based on different dates granularity
Hi Guys,
I have a data as:
-DateTime ("yyyy-MM-dd")
-ReachedUsers
-SuccessReachedUsers
-ReachedRate : SuccessReachedUsers / ReachedUsers
I have the data shown per day (days granularity) but i wish to have a button to show them by months.
What i want to do is to have a toggle button consist of Days and Months and by selecting Days i'll get the following data:
and by selecting Month button i'll get:
I'd appreciate if anyone knows if this can be done and how?
For your case, you'd better use bookmark in power bi.
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
and for the total problem, it seems that total of each day in march on first picture is not same as second picture in mar.
If it is a measure total problem?
please see this post about it
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907If not your case, please share your sample pbix file and your expected output.
Regards,
Lin
6 Replies
- amitchandak
Super User
MohannadSh1996 ,While you can switch Measure using slicer. I think in this case you have to use bookmark
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
MohannadSh1996amitchandak, but how to get the total of column or the percentages of two columns per month?
You can use ALLSELECTED instead of ALL to do this.
To make your measure as general as possible (based on your current model), you could write
P Mix =
DIVIDE (
SUM ( Sheet1[Prior Volume] ),
CALCULATE (
SUM ( Sheet1[Prior Volume] ),
ALLSELECTED ( Sheet1[Product Hier], Sheet1[Product Hier lvl 1], Sheet1[Product Hier lvl 2] )
)
)
Using this measure, the denominator would be determined by any slicers filtering the table.For convenience, it might be better to have a Product table related to your existing table, which would simplify the above measure since you could write ALLSELECTED ( 'Product' ).
- MohannadSh1996
Anonymous
ALLSELECTED will not solve the problem .. could you please send a more clear query to calculate total by month?
v-lili6-msftCommunity Support
For your case, you'd better use bookmark in power bi.
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
and for the total problem, it seems that total of each day in march on first picture is not same as second picture in mar.
If it is a measure total problem?
please see this post about it
https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907If not your case, please share your sample pbix file and your expected output.
Regards,
Lin
