Forum Discussion
Not Displaying Values on Chart
Hi Arranafc19 ,
To create a measure as below.
Measure =
VAR alle =
CALCULATE (
SUM ( Table1[sales] ),
FILTER ( ALLSELECTED ( Table1 ), Table1[month] <> BLANK () )
)
VAR su =
CALCULATE (
SUM ( Table1[sales] ),
FILTER ( Table1, Table1[month] <> BLANK () )
)
RETURN
IF ( MAX ( Table1[month] ) = BLANK (), BLANK (), DIVIDE ( su, alle ) )
Hi v-frfei-msft
Having looked at your solution , it looks as though you are excluding the null values from the percentage calculation which is not what I am looking for .
I need the value of sales for month null to be included in the percentage calcuation but not to be displayed on the chart , as I am trying to get a percentage closed per month of overall.
Is there a way to do this ?
You can use the same measure for both.
Click the chart, and on the right, select month (or add it if needed) in Visual level filters > Advanced Filtering > Show items when the value: is not blank > Apply Filter
Cmcmahan if I do this , will this alter the percentage values by excluding the values ?
Basically I need to get the percetage of sales that are completed by month of the overall total. If I use the filter , I will be excluding the ones that havent sold which will affect my percentages.
That depends on the measure you're using to calculate the percentage. If you could share that with us, I can take a look to make sure it won't break.
Cmcmahan if I do this , will this alter the percentage values by excluding the values ?
Basically I need to get the percetage of sales that are completed by month of the overall total. If I use the filter , I will be excluding the ones that havent sold which will affect my percentages.
