The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi everyone,
so i`m working on this dashboard where i want to visualize the the different intervalls how old receivables are on a geo map and use a slicer to give the user the opportunity to click through the different categories.
For that purpose i want to use the columns i have in my table (1 to 30 days, 31 - 60 days, 61 - 90, etc.) where the monetary amount of the receivable is stored. I want now the column names (1 to 30 days, etc.) as a category to build it into a slicer with a different color based on what category is selected (from good to bad or red to green)
I really don`t have a clue how to categorize columns. I tried several things but none of them worked.
You help is appreciated!
How can
Hi,
Share some data and show the expected result.
You can't using column names in slicers, you could try unpivoting your age columns (1 to 30 days, 31 - 60 days, 61 - 90, etc.) into a two columns (an age and a value), then you could use this in slicers or as a category in other visuals.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
79 | |
73 | |
46 | |
39 |
User | Count |
---|---|
135 | |
108 | |
69 | |
64 | |
56 |