Power BI - drill down on line chart
I have a table such as below in Power BI. I want to create a line chart that drills Animal-> Subcategory. I have Date in the x axis, Value in the y-axis and Animal in the legend field. I can add another field to the legend field. Does anybody know how I can do that?
I also have an Animal filter at the top, when selecting an animal, it would be nice if the chart would automatically update to show the subcategory
| Date | Animal | Subcategory | Value |
|---|---|---|---|
| 2024-01 | Cat | Siamese | 100 |
| 2024-01 | Cat | Persian | 150 |
| 2024-01 | Dog | Bulldog | 200 |
| 2024-01 | Dog | Beagle | 250 |
| 2024-01 | Bird | Parrot | 300 |
| 2024-02 | Bird | Sparrow | 350 |
This can be done using a Field Parameter. It will need to be enabled before it can be used. Steps to enable it can be found here.
Create a new Field Parameter and add Animal and Subcategory to it.
Add this new Field Parameter to the Legend of your visual. Use the autogenerated slicer to switch between Animal and Subcategory.
Subcategory Selected:
- Remove Alphanumeric string and following character from end of the string in power BI
- 'Exclude' slicer in Power BI
- Limiting a Slicer's Multi-Select Options by A Category
- Vega multi-line chart messed up by moving brushed area but works with fold
- Using a DAX Query to calculate a maximum value for each of my projects from two tables in a many to one relationship
- Pass a Terraform Output to an Azure DevOps Varibale
- load data into power BI from relative path
- Power BI Bacci's Gantt 2.0 - Center "Today" within viewport?
- PowerBI - Bug in function LOOKUPVALUE?
- Measure using PREVIOUSYEAR is returning BLANK on card visual but works on matrix
- how to append two columns in the same table in Power BI
- How to prevent Vega signals from resetting when changing Deneb input data via Power BI slicers
- Power BI - Unable to add icons to my table visual
- Power BI :: Calendar Table doesn't have the calendar icon
- Trying to calculate change over time using a SUMX function with DAX. but the value I get is cumulative value--how can I get the non-cumulative value?
- Data Refresh Time Estimate for Incremental Refresh without Query Folding
- How to leverage previous value in dax without yielding a circular dependency?
- How to decide between using the SharePoint folder vs web connector to access excel file?
- How to handle multiple dimension records having the same name even though they have unique key/relation with the fact table (1:M)?
- How to get historical exchange rate data from the European Central Bank API?
- How to set default of Gantt in Deneb-Vega to "ALL" instead of "Days"
- Where does one go to view the query error?
- Query regarding MDX CALL statements for stored procedures in Power BI
- Is there a way to change a True False to Yes No in PowerBI Slicer visual
- Can Incremental Refresh Work Without Query Folding?
- Vega performant toggling visibility of marks
- If the data source is a SQL Server stored procedure in PowerBI, is it possible to do query folding in PowerQuery?
- multi conditional for conditional column power query
- Add and remove items from an array using Vega signals
- select specific columns from a dataset using Vega