Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
i want to only show only two specific values of a certain column in the donut chart. If we suppose that a column that is chosen as a dimension for a donut chart, contains six different values, then the six values will be show in the donut chart. However i only want three of them to be shown and the other three must be ignored. For the example of the chart below, three types of flavors are shown. What i want to do, is showing only strawberry and chocolate and ignoring vanilla. How can i do this? thank u in advance.
Hi, just define your flavors (3 certain values) in your percentage measure, something like:
Sum({<flavor = {'Strawberry', 'Chocolate', 'Vanilla'}>} [your_measure_field])
@yacine You can use the set analysis to resolve this issue.
As per your above requirement where you wanted to show only Strawberry and Chocolate:
Sum({<Flavor={'Strawberry ','Chocolate'}>}Amount)
This should resolve your issue.