Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All
I have a scatter plot where the X and Y axis should vary based on inputs into a selection slicer. The Y-axis changes based on the selection from a calculated column.
The X axis is a measure calculation using the 'IntentWeight' slicer. On the plot all x values are the same, 870.55. For some reason it is taking the total at the bottom of the table. How can I fix this?
I tried using a calculated column instead of a measure and that works as shown below: But now the values dont update with the slicer!
Basicaly I need my graph to look like this ^^ But also have the values update with the slicer selection!
Thank you to anyone who can help me with this problem!
Hi @NNaj ,
Can you provide some sample data with measure,calculated column to make it easier to test?
Much appreciated.
Company | Intensity Selection | Value |
Company 1 | A | 1 |
Company 2 | A | 2 |
Company 3 | A | 3 |
Company 1 | B | 4 |
Company 2 | B | 5 |
Company 3 | B | 6 |
Company 1 | C | 7 |
Company 2 | C | 8 |
Company 3 | C | 9 |
Company 1 | D | 10 |
Company 2 | D | 1 |
Company 3 | D | 2 |
This is the data for the y-axis. The slicer has intensity selection and if you select A only a sum of those values are shown on the graph aggregated by company. This is a column (no measures in this table).
The X-axis has this data
Company | Feature | Value (Measure) |
Company 1 | x | 3 |
Company 2 | y | 2 |
Company 3 | z | 4 |
Company 1 | x | 5 |
Company 2 | y | 3 |
Company 3 | z | 4 |
Company 1 | x | 5 |
Company 2 | y | 6 |
Company 3 | z | 4 |
Company 1 | x | 3 |
Company 2 | y | 2 |
Company 3 | z | 4 |
in the drop down you select all the features and those will be used in the measure to calculate the value column. Plotting this on the scatter graph doesnt work as shown in the screenshots above. the total of the value column is plotted for all companies (I cant click 'dont summarize as its a measure). When I made this measure a column, I was able to click 'dont summarize' but now the values dont update.
Thank you
Hi @NNaj ,
Sorry but I cant reproduce your senario based on your data,see below:
Can you deploy the chart in my .pbix file?Better advise me what measure or calculated column you are using.
@NNaj , not sure I got it, But see if this can help. How to change the value of measure using slicer.
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |