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:
- Powerquery: how to convert/cast type Type to type Text?
- Power BI make Measure static Value and dynamic
- Power bi deneb vega timer issue
- How to use ORDER BY in Power BI DAX
- PowerBI PowerQuery: Token In expected
- Sorting does not work after adding a new major model and sub-models
- Power Bi Custom Visual: column order is incorrect
- Deneb (Vega-lite) - Sorting Axis
- IF second char in value is 'X' output should be existing first char + 'X'
- Power Query `List.Generate` runs too slow
- Multi-layer x-axis Date setup in Vega-Lite
- Power BI table shows one of the column values in the total instead of the column sum
- How do I return the value in a column that closest matches another column in Power Query
- Vega-Lite (Deneb) | Waterfall Chart (Start & End Column Problem)
- Power BI Embed URL-multiple filters
- Get Average of Top 3 in a Summarized Table in Power Bi
- How to Merge Duplicate Rows and Sum Numeric Values in Power BI When Cleaning Sales Data from Multiple Regions?
- TOTAL is correct but rows are missing
- Custom Colum based on specific dates in powerquery
- Dax - how to get average value per day where column x value is y?
- Is there a way to create a shareable link for a Power BI report using Power BI REST APIs?
- Fixed values but variable year
- Power bi desktop table visual out of memory on a simple DAX
- Possible to load .SQL file to Power bi?
- Power BI Sorting stacked columns
- Update dataset of the Power BI Report
- Use DAX Query to create table in Power BI
- Click event handler on bar chart in PowerBI embed
- Subtraction of previous period in PowerQuery
- Split column after getting multiple different CSV's into PowerBI/PowerQuery