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'm new to PBI and maybe my issue can be solved by a completely different approach, and a different visualization. However I can't come up with an easy solution to this.
I want to have a table with multiple raws and one column (measure).
Here is some sample data (very simplyfied):
page||sessions||date home|100|2018-01-01
home|80|2018-02-01 sub|150|2018-01-01 cat|200|2018-01-01 bar|50|2018-01-01
Now I want to use table to visualize this data. The measure is "sessions" but the raws should represent filtered values. For example:
raw01=(filter page == home) AS "home"
raw02=(filter page == sub OR page == cat) AS "s&c"
So my visual should look like this table:
raws||sessions home|180 s&c|350
I boiled down all complexity to the minimum, in hope to make my question as abstract as possible.
My goal is to have filtered values (by multiple conditions) within a table as an overview. Right now I achieve this with multiple tables (every table with its own filter) and custom columns (which are created by a way to complicated R script to return if REGEX criteria is met, since I cant find a way to use AND operator in derived columns and REGEX).
Solved! Go to Solution.
Easiest thing to do would to create calculated column with an IF or SWITCH statement that spits out the actual text that you want and then just put that column in a table with your measure.
Easiest thing to do would to create calculated column with an IF or SWITCH statement that spits out the actual text that you want and then just put that column in a table with your measure.
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |