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.
Hi,
I have a specific query I am trying to solve for.
I have a table that looks like this which has Customer, Unique Click Count(Measure), and Segments(Measure).
I am trying to Group this data like the table and visual below which I have made in Excel.
Index Funds & Stocks | 3 |
Index Funds Only | 2 |
Nothing | 42 |
Stocks Only | 2 |
is this possible in Power BI
The PBIX I am working with: Segments.pbix - Google Drive
in order to place the categorical segments on the axis it needs to be a column not a measure so you will need to do some remodelling of your data. Did you want a separate table for segments?
Proud to be a Super User!
I have a disconnected Segments table, is there a way I can use this is the measure to group the click counts by segment?
you can only slice a measure by categorical data, you can't slice it using a measure.
There are other ways to model this data but it all depends on why you are trying to do it the way you are, as there are other ways to model this. What is your objective?
Proud to be a Super User!
The objective is to display whose clicking on articles based on their invested segment. I think I'll try a switch measure and link to the disconnected table using SELECTEDVALUE.
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 |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |