Hi,
I have set up a slicer and it works, woohoo! The only problem is that one measure is just a count and the numbers displayed are just regular old, vanilla, whole numbers whereas the other measure is a percentage and I cannot figure out a way to display the whole numbers as whole numbers and the percentages as percentages. The percentages currently display as 0.02, 0.034 etc as opposed to 2%. 3.4%
I have the measures/calcs for my chart and slicer in a slicer table and the line value is the selected measure value. The values pulled come from a separate calculation in my relationship table which calculates the percentage from my total count divided by total dispatched. I would attach a picture of the chart but I can't figure out how to it on here! It's a bar and line graph.
I have tried using the FORMAT function to format the measures as "Percent" but it doesn't work.
I have also tried ensuring that the measures are formatted in modeling as percentages - that works but then my whole numbers are displayed as percentages.
Here is a copy of my slicer measure:
Weekly Selected Measure (2) =
VAR MySelection =
SELECTEDVALUE ( 'Disconnected Slicer Table'[Measure Name], "Issues")
RETURN
SWITCH (
TRUE (),
MySelection = "Issues", [Issues (2)],
MySelection = "Percentage" , [Weekly Percentage (2)],
[Issues]
)
Here is a copy of the measures it is pulling from:
Issues (2) = DISTINCTCOUNT('Order Level'[Order Number])
Weekly Percentage (2) = [Issues (2)] / 'Weekly Dispatch Figures (2)'[Weekly Total dispatches (2)]
Weekly Total dispatches (2) = SUMX(DISTINCT('Weekly Dispatch Figures (2)'[Week]),CALCULATE(AVERAGE('Weekly Dispatch Figures (2)'[Total Dispatches])))
Any help would be greatly appreciated!
Cheers,
Jez
