Forum Discussion
Umadhandapani
Helper II
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. Her...
amitchandak
Super User
Super UserUmadhandapani , 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.