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.
I'm not even sure what this would be called. I have a field called Affiliation, the values are Customer, Dealer, Company, all associated with a site name
In my table I want the site name, #of Customers, # of Dealers
Example:
Site Name # of Customers #of Dealers
1 23 13
2 11 5
3 7 16
How do I filter the Affiliation field to get # of Customers column and still have the Dealer option for the # of Dealers column?
Solved! Go to Solution.
I figured it out, I needed to add Country to the Rows, then expand all and turn off the stepped layout under Row headers format
I figured it out, I needed to add Country to the Rows, then expand all and turn off the stepped layout under Row headers format
@Greg_Deckler almost there, I can't add any other columns or it give me that data for each affiliation in another coulmn, so if i add location, it give me location for customers and location for dealers, I only want location for each site
@gilmore_staci Use a Matrix visual and use Affiliation as the Columns?
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 |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
138 | |
107 | |
104 | |
82 | |
63 |