Hi, thanks for your response
Its a Million -
and I am looking for way dunamic conversion so that I can use K to M or M to billions
The only way I know to do this is to manually create a text field to use as a label. Since it's text, you'd still need to use your numeric KPI field to create any visualizations or do calculations. For example here I used the KPI field to create a bar chart, but put the text label on the Marks Card.
Workbook is attached.
Thanks for your prompt response.
My requirement is I have filter on counties - when I select "All" from the filter values,it should show Billions/Millions and when I select individual countries from same filter values should change Millions/K .
example1 : if I select All countries from the country filter:
example2 : if I select one country from the same country filter:
this way dynamic change which I am looking
thanks in advance