Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
PeRoma
Frequent Visitor

Values in different columns based on different filters

Hi,

I want to show in a table visual 2 columns that are based on the same data column with different filters: My fact-sheet contains prices for articles in different countries. There is a dimension with all articles. I want to create a table visual that shows prices of different countries in different columns of one row.

Thanks for any ideas!

 

PeRoma

 

Article Table  Price Table   
       
articlecategory articlecountrypricesince
ac aU21.2.
bd aM32.1.
ce bC44.3.
   bM66.12.
   cC77.4.
   cU85.7.
       
The Table I want to have     
       
ArticleCUM   
a 23   
b4 6   
c78    
1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@PeRoma , Join both the table on the article

 

In matrix visual take article on row , Country on column and Sum/Max of price on values

View solution in original post

3 REPLIES 3
amitchandak
Super User
Super User

@PeRoma , Join both the table on the article

 

In matrix visual take article on row , Country on column and Sum/Max of price on values

Hi amidchandak,

the solution has been to easy to be true. But this is, because I did not tell you everything: I need some more columns beside these "aggregated" columns. So I am stuck with a Matrix. Is there another way for this problem? I would like not to modify my data-sheets.

Thanks! I did not expect to be that easy!

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.