Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Here's a simplified version of what I'd like to see in my report.
ID_Table
ID Outages
1 3
2 2
The "Outages" Column would be calculated with something like:
=CALCULATE(COUNT(Outage_Table[ID]),ALLEXCEPT(ID_Table,ID_Table[ID]))
Outage_Table
ID Date
1 8/9/2018
1 8/10/2018
1 8/11/2018
2 8/9/2018
2 8/10/2019
What I would love to see is having two filter, one that allows me to adjust the number of outages, so that I can see all customers with more than 4 outages for example, but I would also like to be able to say "How many customers have had 4 or more outages in the last 3 months"
Because I'm using a calculated column, it doesn't adjust based on the filter. Is there a good workaround?
Solved! Go to Solution.
I think the only way to do this is have Columns and not meassures in a hierarchy table sort of say.
If you do all this in Excel and upload your final table for a full year of data, then you could have the different values accross slicers and all would be in sync
I think the only way to do this is have Columns and not meassures in a hierarchy table sort of say.
If you do all this in Excel and upload your final table for a full year of data, then you could have the different values accross slicers and all would be in sync
I figured as much. Thanks for the help!
You may also take a look at https://community.powerbi.com/t5/Desktop/Create-a-bar-graph-with-measures-as-axis/td-p/455900.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |