Forum Discussion
Isolate measure from graph category
- 5 years ago
Hi all,
First of all thank you for your your replies and the time you put into my challenge!
I did not came directly to the solution using yourt input on my challenge. In fact I was a bit overwhelmed by the complexity of especially the references to hierachies and INSCOPE functions.
After a lot of searching and reading through a lot more of complex solution, I found a solution very deas imple as I was expected it to be.
First I created the following formula:
#ShipmentsAllMethods = Calculate(Sum('table1'[Shipments]), ALL('table1'[Shipment_method])
Then I created a conditional data color formatting, where if the value is between 0-30 light pink, when value > 30 white.
I did the same for creating graphs with other categories like payment_method or shipment_country.
Hope this simple solution will help others with the same problem.
Again, many thanks guys!
Hi all,
First of all thank you for your your replies and the time you put into my challenge!
I did not came directly to the solution using yourt input on my challenge. In fact I was a bit overwhelmed by the complexity of especially the references to hierachies and INSCOPE functions.
After a lot of searching and reading through a lot more of complex solution, I found a solution very deas imple as I was expected it to be.
First I created the following formula:
#ShipmentsAllMethods = Calculate(Sum('table1'[Shipments]), ALL('table1'[Shipment_method])
Then I created a conditional data color formatting, where if the value is between 0-30 light pink, when value > 30 white.
I did the same for creating graphs with other categories like payment_method or shipment_country.
Hope this simple solution will help others with the same problem.
Again, many thanks guys!