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.
Hello,
I have a table (Tab1) with data as mentioned below. Column NLH is a measure column.
I want to display a visulaization something like below -
Could you please help to resolve this?
Thanks! in Advance.
Solved! Go to Solution.
@DannyGarnep
It can be solved in one of 3 ways or, instead of a measure, it can be calculated in the calculated column.
You can also use field parameters
Or create a summarized table with your measure.
For a more detailed solution
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
You have to create following new measure:
Count =
CALCULATE (
COUNT ( Tab1[NLH(Measure)] ),
ALLEXCEPT ( Tab1, Tab1[NLH(Measure)], Tab1[Month] )
)
Then use matrix visuals to plot your fields:
Rows: NLH(Measure)
Columns: Month
Values: Count (the new measure which we created)
Instead of using NLH as measure you have to Create NLH as a calculated Columns so that You can use it as row in matrix visual.
Please mark my solution as accepted if it helped you!
Hi @DannyGarnep
I wasn't quite sure what was meant by "measure column."
However, according to your data structure, you must display it as a matrix like on the picture:
It is important to note that to have months appear chronologically, you must add a numeric column for each month and sort the names of the months by their numeric value
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Thank you! @Ritaf1983
I am not able to add the NLH to Rows in the visualization. This is a derived/calculated column.
Anyother possible way to resolve?
@DannyGarnep
It can be solved in one of 3 ways or, instead of a measure, it can be calculated in the calculated column.
You can also use field parameters
Or create a summarized table with your measure.
For a more detailed solution
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
@DannyGarnep use Field Parameters to achieve this
Proud to be a Super User!
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 |
---|---|
114 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |