The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi,
I have three columns value in my Power BI report
let's just name them column1, column2, column3
I'm wondering if there is a visualization in Power BI that can show their sum value randomly
For example, in this visualization,
I can either select to show the sum value of column1+column2+column3 all toghther
or show two of them like column1 + column3, column2+ column3, and column1+column2 etc
or just single column's value
I hope there is a selector in the visualization that I can select the columns' value I want to show as sum
Is there a way in Power BI to do that?
Thanks
Solved! Go to Solution.
Hi @Anonymous,
Please unpivot the table and use a Matrix visual to display data.
Apply below steps in Query Editor mode.
Add an index column.
Select Column1, Column2 and Column3 at a time, then, Unpivot. Rename the new generated columns.
Drag [ColumnName] into a slicer. Insert a Matrix visual, place [Index] into "Rows", [ColumnName] into "Columns" and [Value] into values.
Best regards,
Yuliana Gu
Hi @Anonymous,
Please unpivot the table and use a Matrix visual to display data.
Apply below steps in Query Editor mode.
Add an index column.
Select Column1, Column2 and Column3 at a time, then, Unpivot. Rename the new generated columns.
Drag [ColumnName] into a slicer. Insert a Matrix visual, place [Index] into "Rows", [ColumnName] into "Columns" and [Value] into values.
Best regards,
Yuliana Gu
Thanks a lot, Yuliana
DAX has a random number generator function:
https://docs.microsoft.com/en-us/dax/rand-function-dax
You could attempt to write a SUMX function that goes through each value in your table, then use the RAND function in a nested IF statement to choose which values to grab a value from.
Not sure what the output would be like, but it seems possible.