Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Display % for Specific Slicer Selection. Display Decimal Otherwise.
05-10-2023
07:52 AM
Does anyone know if this can be achieved?
I have a table which uses a slicer to provide calculations for 9 different metrics. When you select that metric in the slicer, it displays the totals in the table. However, 2 of the metrics are percentage based. The rest are averages (decimal numbers).
Can the format be dynamic in this way?
Solved! Go to Solution.
1 ACCEPTED SOLUTION
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-12-2023
08:58 AM
Found my solution with the new feature that has been added:
https://powerbi.microsoft.com/en-ie/blog/deep-dive-into-the-new-dynamic-format-strings-for-measures/
1 REPLY 1
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-12-2023
08:58 AM
Found my solution with the new feature that has been added:
https://powerbi.microsoft.com/en-ie/blog/deep-dive-into-the-new-dynamic-format-strings-for-measures/

Helpful resources
Featured Topics
Top Kudoed Authors (Last Month)
User | Count |
---|---|
121 | |
104 | |
88 | |
52 | |
45 |