Number value is adding to Chart as 'Count of'
I have a chart that looks like the below. When I convert this to a line and column, it automatically convert the 'PM Count' column to be 'Count of PM Count' and therefore displays the values incorrectly. Below you can see that field is clearly a numeric value and is formatted as such.
DrillDown issues with different time and value metrics
Hello! Ive been having some issues visualizing in a drill down from the quarters of a year to the months: I have a metric named, # of Backlog Unscheduled Cases (End of Month) that i have to use it in the axis with the time metric (month). The same for, # of Backlog Unscheduled Cases (End of Quarter) but with the time metric quarter. Ive been using this formula cause i want to put these 2 different values ina line chart so i have each metric matched with time metric that correspond. The issue is when i want to see the months because when I make a drill down to see the data divided by months, I just see the data of the beginning of every quarter. For example (month 1, month 4, month 7, month 11). I would like to see the data of the Twelve months(Ive checked the month metric separatedly and it works i visualize all the months, maybe its the formula). Here is a screenshot: ChangeInDrillDown = VAR month1 = 'Fact - Backlog Cases'[# of Backlog Unscheduled Cases (End of Month)] VAR quarter1 = 'Fact - Backlog Cases'[# of Backlog Unscheduled Cases (End of Quarter)] RETURN IF(ISFILTERED('Hierarchy - Fiscal Calendar on Open Date'[FiscalYear]),month1,quarter1)
