HI All,
I have a column 'SalesAmount' in my table 'Monthly'. I'm trying to create Multi-Row card visual that shows in following format:
| Top N filter value of SalesAmount | Its percentage(%) (let's suppose x) |
| Grand Total - Top N filter value of SalesAmount (subtraction) | Percentage % (i.e 100 - x) |
| Grand Total(SalesAmount) | 100 % |
Thus when a user changes the filter value of Top N, the row 1 and row 2 changes dynamically, but row 3 stay intact. (Since Grand total stay same )
How can I achieve this ?
Helpful resources
Europe’s largest Microsoft Fabric Community Conference
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
New forum boards available in Real-Time Intelligence.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Power BI Monthly Update - May 2024
Check out the May 2024 Power BI update to learn about new features.
