Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
Hi
I have a stacked bar chart which is displaying data from two tables
Owners and Data
There is a 1:M relationship between owner and data.
I have created 3 measures to calcualte data that is breached, at risk of being breached and not in breach within the data table.
I have now displayed these measures within the stacked bar chart and it all looks good.
Now what i want is the abilty to select the portion of the bar chart that is Breached and show the data that is breached. Same of At Risk and no in breach.
I cant get this to work. I belive you cant select the measure individually on the stacked bar chart.
Can anyone please assist me?
Thanks
Hi, i want to use POwer bi, not tableu editor?
Tabular Editor is used like a plug-in for Power BI you can write measures, create calculation groups etc. there are loads of options for slicing measures, Switch with the measure name is my go to. here's a video from BI elite explaining it.
Slicing by Measure Categories in Power BI - YouTube
If you can share a sample I can give code examples
is there a way we can acheive this using native DAX?
depending on the measures you may be able to do this using a calculation group in Tabula editor. you can then add a calculation group to a slicer to select specific measures.
its worth reading up on the impact of calculation groups though - this can remove the in report aggregations such as count, sum etc, so you'll have to write these as measure rather than the drop downs.
User | Count |
---|---|
105 | |
69 | |
48 | |
47 | |
47 |