Forum Discussion
Helper IITwo Totals in Matrix Table
Hi, in the image it states two different values, the green color against sales and pink against profit.
Based on the till month selected it will show the sales value, remaining profit.
Here, I required two different totals to be display stating sales and profit seperately.
5 Replies
- amitchandak
Super User
Umadhandapani , As I commented on yesterdays post, this might require an independent table , or you can use slicer date table/column, in place of date1/date1[date]
Create a color measure and use that in conditional formatting using field value option
Color measure =
var _max = maxx(allselected(Date1),Date1[Date]) // slicer is on an independent date table// OR you can use your slicer date column
return
if( max('Date'[Date]) <=_max) ,"Green", "Red")How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4
UmadhandapaniHi , required two different total to be display with one showing sum of sales and another sum of profit based on the slicer selection.
- Umadhandapani
Hi, whether two totals can be created dynamically.
Your needs are not very clear, can you provide the original data(without private information) ? When you choose other month , what should be the total ?
Best Regard
Community Support Team _ Ailsa Tao
- Umadhandapani
Actually, along with total required sales total and profit total.(with three total column)
